subquery_assumeorderby.sql 200 B

123456789
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. define subquery $sub() as
  4. select * from (values (1),(2),(3)) as a(x);
  5. end define;
  6. $sub2 = SubqueryAssumeOrderBy($sub, [("x",true)]);
  7. process $sub2();