1
2
3
4
5
6
7
8
9
10
11
12
|
/* postgres can not */
PRAGMA DisableAnsiInForEmptyOrNullableItemsCollections;
SELECT
1 IN (2,3,null), -- false
1 IN (null), -- false
(1, null) IN ((1,2), (1, 3), (1, null)), -- Nothing<Bool?>
(1, 1) IN ((1,null)), -- false
(1, 1) IN ((1,1),(2,null)), -- true
(1, null) IN ((1,2), (1,3)), -- Nothing<Bool?>
(2, null) IN ((1,2), (1,3)), -- Nothing<Bool?>
(1, null) IN (); -- Nothing<Bool?>
|
