table_funcs_expr.sql 796 B

12345678910111213141516
  1. /* postgres can not */
  2. /* syntax version 1 */
  3. use plato;
  4. select count(*) from concat("Inp"||Unicode::ToLower("ut"u));
  5. select count(*) from concat_strict("Inp"||Unicode::ToLower("ut"u));
  6. select count(*) from range("","Inp" || Unicode::ToLower("ut"u));
  7. select count(*) from range_strict("","Inp" || Unicode::ToLower("ut"u));
  8. select count(*) from filter("",($x)->{return $x == "Input"});
  9. select count(*) from filter_strict("",($x)->{return $x == "Input"});
  10. select count(*) from like("","Inp" || "%");
  11. select count(*) from like_strict("","Inp" || "%");
  12. select count(*) from regexp("","Inp" || ".t");
  13. select count(*) from regexp_strict("","Inp" || ".t");
  14. select count(*) from each(AsList("Input"));
  15. select count(*) from each_strict(AsList("Input"));
  16. select count(*) from folder(SUBSTRING("foo",0,0));