pass_subquery_as_param.sql 244 B

12345678910111213
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. define subquery $dup($x) as
  4. select * from $x(1)
  5. union all
  6. select * from $x(2);
  7. end define;
  8. define subquery $sub($n) as
  9. select $n * 10;
  10. end define;
  11. select * from $dup($sub);