subquery_merge2.sql 324 B

1234567891011121314151617
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. define subquery $sub($i) as
  4. select $i as x;
  5. end define;
  6. $s = SubqueryExtendFor([1,2,3],$sub);
  7. process $s();
  8. $s = SubqueryUnionAllFor([1,2,3],$sub);
  9. process $s();
  10. $s = SubqueryMergeFor([1,2,3],$sub);
  11. process $s();
  12. $s = SubqueryUnionMergeFor([1,2,3],$sub);
  13. process $s();