eval_if.sql 374 B

123456789101112131415161718
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. USE plato;
  4. define action $action1($x) as
  5. select $x;
  6. end define;
  7. evaluate if CAST(Unicode::ToUpper("i"u) AS String) == "I"
  8. do $action1(1)
  9. else
  10. do $action1(2);
  11. evaluate if CAST(Unicode::ToUpper("i"u) AS String) != "I"
  12. do $action1(3);
  13. evaluate if CAST(Unicode::ToUpper("i"u) AS String) == "I"
  14. do $action1(4);