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


1
2
3
4
5
6
7
8

/* syntax version 1 */
/* postgres can not */
define subquery $sub($a,$b?) as
    select $a + ($b ?? 0);
end define;

process $sub(1);
process $sub(2, 3);