yql/essentials/tests/sql/suites/pg/expr_op_array.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

--!syntax_pg
select 1 = any(array[1,2]), 
       1 = any(array[2,3]), 
       2 = all(array[2,2]), 
       2 = all(array[2,3]),
       1 = any(array[null,1]),
       1 = any(array[null,2]),
       1 = all(array[null,1]),
       1 = any(null::_int4),
       1 = all(null::_int4),
       null = any(array[1,2]),
       null = all(array[1,2]),
       null = any(null::_int4),
       null = all(null::_int4);