yql/essentials/tests/sql/suites/action/pass_subquery_as_param.sql


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

/* syntax version 1 */
/* postgres can not */
define subquery $dup($x) as
   select * from $x(1)
   union all
   select * from $x(2);
end define;

define subquery $sub($n) as
   select $n * 10;
end define;
           
select * from $dup($sub);