runtime_if_select.sql 434 B

1234567891011121314151617181920212223242526272829
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. use plato;
  4. insert into @foo
  5. select count(*) as count from Input;
  6. commit;
  7. $n = (select count from @foo);
  8. $predicate = $n > 1;
  9. if $predicate do begin
  10. select 1;
  11. end do;
  12. if not $predicate do begin
  13. select 2;
  14. end do;
  15. if $predicate do begin
  16. select 3;
  17. end do else do begin
  18. select 4;
  19. end do;
  20. if not $predicate do begin
  21. select 5;
  22. end do else do begin
  23. select 6;
  24. end do;