| /dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/net-mgmt/netdisco/App-Netdisco-2.047002/lib/App/Netdisco/Web/Plugin/Report/ |
| H A D | NodesDiscovered.pm | 49 ('me.remote_type' => { -ilike => 'AP:%' }) : ()),
51 ('me.remote_type' => { -ilike => '%ip_phone%' }) : ()),
53 ('me.remote_id' => { -ilike => scalar sql_match(param('remote_id')) }) : ()),
55 map {( 'me.remote_type' => { -ilike => scalar sql_match($_) } )}
|
| /dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql12-docs/postgresql-12.9/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql12-server/postgresql-12.9/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql12-contrib/postgresql-12.9/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql12-plperl/postgresql-12.9/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql12-plpython/postgresql-12.9/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql12-pltcl/postgresql-12.9/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql13-server/postgresql-13.5/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql13-contrib/postgresql-13.5/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql13-client/postgresql-13.5/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql13-plperl/postgresql-13.5/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/postgresql13-docs/postgresql-13.5/src/test/regress/sql/ |
| H A D | btree_index.sql | 66 select proname from pg_proc where proname ilike '00%foo' order by 1;
67 select proname from pg_proc where proname ilike '00%foo' order by 1;
69 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
77 select proname from pg_proc where proname ilike '00%foo' order by 1;
78 select proname from pg_proc where proname ilike '00%foo' order by 1;
80 select proname from pg_proc where proname ilike 'ri%foo' order by 1;
|
| /dports/databases/pgrouting/pgrouting-3.2.0/sql/common/ |
| H A D | pgrouting_utilities.sql | 437 when v1a[4] ilike 'rc%' then 4
438 when v1a[4] ilike 'beta%' then 3
439 when v1a[4] ilike 'alpha%' then 2
440 when v1a[4] ilike 'dev%' then 1
444 when v2a[4] ilike 'rc%' then 4
445 when v2a[4] ilike 'beta%' then 3
446 when v2a[4] ilike 'alpha%' then 2
447 when v2a[4] ilike 'dev%' then 1
|
| /dports/databases/postgresql96-server/postgresql-9.6.24/contrib/pg_trgm/sql/ |
| H A D | pg_trgm.sql | 56 select * from test2 where t ilike '%BCD%';
60 select * from test2 where t ilike '%BCD%';
61 select * from test2 where t ilike 'qua%';
94 select * from test2 where t ilike '%BCD%';
98 select * from test2 where t ilike '%BCD%';
99 select * from test2 where t ilike 'qua%';
|