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


1
2
3
4
5
6
7
8
9
10
11

--!syntax_pg
select x = any (select 1)
from (values (1,1),(2,5),(3,4)) a(x,y);

select *
from (values (1,1),(2,5),(3,4)) a(x,y)
where x = all (select 1);

select 1
from (values (1,1),(2,5),(3,4)) a(x,y)
order by x in (select 1);