aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/pg/table_func.sql
blob: 3d481c9cf8918a34c8c6445b399944bfe2cee5d7 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
--!syntax_pg
select count(*) from plato.concat('Input','Input');
select count(*) from plato.concat_view('Input','raw','Input','raw');
select count(*) from plato.range('');
select count(*) from plato.range('','A');
select count(*) from plato.range('','A','Z');
select count(*) from plato.range('','A','Z','');
select count(*) from plato.range('','A','Z','','raw');
select count(*) from plato.regexp('','Inpu.?');
select count(*) from plato.regexp('','Inpu.?','');
select count(*) from plato.regexp('','Inpu.?','','raw');
select count(*) from plato.like('','Inpu%');
select count(*) from plato.like('','Inpu%','');
select count(*) from plato.like('','Inpu%','','raw');