Home
last modified time | relevance | path

Searched refs:ILIKE (Results 1 – 25 of 1516) sorted by relevance

12345678910>>...61

/dports/graphics/qgis/qgis-3.22.3/resources/function_help/json/
H A DILIKE2 "name": "ILIKE",
11 { "expression":"'A' ILIKE 'A'", "returns":"1"},
12 { "expression":"'A' ILIKE 'a'", "returns":"1"},
13 { "expression":"'A' ILIKE 'B'", "returns":"0"},
14 { "expression":"'ABC' ILIKE 'b'", "returns":"0"},
15 { "expression":"'ABC' ILIKE 'B'", "returns":"0"},
16 { "expression":"'ABC' ILIKE '_b_'", "returns":"1"},
17 { "expression":"'ABC' ILIKE '_B_'", "returns":"1"},
18 { "expression":"'ABCD' ILIKE '_b_'", "returns":"0"},
19 { "expression":"'ABCD' ILIKE '_B_'", "returns":"0"},
[all …]
/dports/graphics/qgis-ltr/qgis-3.16.16/resources/function_help/json/
H A DILIKE2 "name": "ILIKE",
10 { "expression":"'A' ILIKE 'A'", "returns":"1"},
11 { "expression":"'A' ILIKE 'a'", "returns":"1"},
12 { "expression":"'A' ILIKE 'B'", "returns":"0"},
13 { "expression":"'ABC' ILIKE 'b'", "returns":"0"},
14 { "expression":"'ABC' ILIKE 'B'", "returns":"0"},
15 { "expression":"'ABC' ILIKE '_b_'", "returns":"1"},
16 { "expression":"'ABC' ILIKE '_B_'", "returns":"1"},
17 { "expression":"'ABCD' ILIKE '_b_'", "returns":"0"},
18 { "expression":"'ABCD' ILIKE '_B_'", "returns":"0"},
[all …]
/dports/databases/postgis32/postgis-3.2.0/extras/tiger_geocoder/normalize/
H A Dnormalize_address.sql258 …WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)' || ws || name || '('
265 …WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)' || ws || name || '('
304 WHERE fullStreet ILIKE '%' || name || '%' AND
311 WHERE fullStreet ILIKE '%' || name || '%' AND
331 WHERE fullStreet ILIKE '%' || name || '%' AND
336 || ')(?:' || ws || '|$)') OR (is_hw AND fullstreet ILIKE name || ' %') )
437 tempString ILIKE '%' || name || '%'
476 … WHERE result.location ILIKE '%' || name || '%' AND texticregexeq(result.location, '(?i)^'
528 WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)'
584 … WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)' || ws || name
[all …]
H A Dlocation_extract_place_exact.sql24 WHERE place.statefp = lstate AND fullStreet ILIKE '%' || name || '%'
28 WHERE fullStreet ILIKE '%' || name || '%' AND
37 WHERE place.statefp = lstate AND fullStreet ILIKE '%' || name || '%'
48 WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)'
/dports/databases/postgis31/postgis-3.1.4/extras/tiger_geocoder/normalize/
H A Dnormalize_address.sql258 …WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)' || ws || name || '('
265 …WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)' || ws || name || '('
304 WHERE fullStreet ILIKE '%' || name || '%' AND
311 WHERE fullStreet ILIKE '%' || name || '%' AND
331 WHERE fullStreet ILIKE '%' || name || '%' AND
336 || ')(?:' || ws || '|$)') OR (is_hw AND fullstreet ILIKE name || ' %') )
437 tempString ILIKE '%' || name || '%'
476 … WHERE result.location ILIKE '%' || name || '%' AND texticregexeq(result.location, '(?i)^'
528 WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)'
584 … WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)' || ws || name
[all …]
H A Dlocation_extract_place_exact.sql24 WHERE place.statefp = lstate AND fullStreet ILIKE '%' || name || '%'
28 WHERE fullStreet ILIKE '%' || name || '%' AND
37 WHERE place.statefp = lstate AND fullStreet ILIKE '%' || name || '%'
48 WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)'
/dports/databases/postgis30/postgis-3.0.4/extras/tiger_geocoder/normalize/
H A Dnormalize_address.sql258 …WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)' || ws || name || '('
265 …WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)' || ws || name || '('
304 WHERE fullStreet ILIKE '%' || name || '%' AND
311 WHERE fullStreet ILIKE '%' || name || '%' AND
331 WHERE fullStreet ILIKE '%' || name || '%' AND
336 || ')(?:' || ws || '|$)') OR (is_hw AND fullstreet ILIKE name || ' %') )
437 tempString ILIKE '%' || name || '%'
476 … WHERE result.location ILIKE '%' || name || '%' AND texticregexeq(result.location, '(?i)^'
528 WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)'
584 … WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)' || ws || name
[all …]
H A Dlocation_extract_place_exact.sql24 WHERE place.statefp = lstate AND fullStreet ILIKE '%' || name || '%'
28 WHERE fullStreet ILIKE '%' || name || '%' AND
37 WHERE place.statefp = lstate AND fullStreet ILIKE '%' || name || '%'
48 WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)'
/dports/databases/postgis25/postgis-2.5.5/extras/tiger_geocoder/normalize/
H A Dnormalize_address.sql258 …WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)' || ws || name || '('
265 …WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)' || ws || name || '('
304 WHERE fullStreet ILIKE '%' || name || '%' AND
311 WHERE fullStreet ILIKE '%' || name || '%' AND
331 WHERE fullStreet ILIKE '%' || name || '%' AND
336 || ')(?:' || ws || '|$)') OR (is_hw AND fullstreet ILIKE name || ' %') )
437 tempString ILIKE '%' || name || '%'
476 … WHERE result.location ILIKE '%' || name || '%' AND texticregexeq(result.location, '(?i)^'
528 WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)'
584 … WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)' || ws || name
[all …]
H A Dlocation_extract_place_exact.sql24 WHERE place.statefp = lstate AND fullStreet ILIKE '%' || name || '%'
28 WHERE fullStreet ILIKE '%' || name || '%' AND
37 WHERE place.statefp = lstate AND fullStreet ILIKE '%' || name || '%'
48 WHERE fullStreet ILIKE '%' || name || '%' AND texticregexeq(fullStreet, '(?i)'
/dports/databases/pg_citus/citus-10.2.3/src/test/regress/expected/
H A Disolation_citus_dist_activity.out35 …atname FROM citus_dist_stat_activity WHERE query NOT ILIKE '%pg_prepared_xacts%' AND query NOT ILI…
45 …name FROM citus_worker_stat_activity WHERE query NOT ILIKE '%pg_prepared_xacts%' AND query NOT ILI…
105 …atname FROM citus_dist_stat_activity WHERE query NOT ILIKE '%pg_prepared_xacts%' AND query NOT ILI…
115 …name FROM citus_worker_stat_activity WHERE query NOT ILIKE '%pg_prepared_xacts%' AND query NOT ILI…
169 …atname FROM citus_dist_stat_activity WHERE query NOT ILIKE '%pg_prepared_xacts%' AND query NOT ILI…
179 …name FROM citus_worker_stat_activity WHERE query NOT ILIKE '%pg_prepared_xacts%' AND query NOT ILI…
236 …atname FROM citus_dist_stat_activity WHERE query NOT ILIKE '%pg_prepared_xacts%' AND query NOT ILI…
246 …name FROM citus_worker_stat_activity WHERE query NOT ILIKE '%pg_prepared_xacts%' AND query NOT ILI…
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/
H A Dbtree_index.sql128 proname ILIKE '00%foo'
137 proname ILIKE '00%foo'
149 proname ILIKE 'ri%foo'
186 proname ILIKE '00%foo'
195 proname ILIKE '00%foo'
207 proname ILIKE 'ri%foo'
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/
H A Dstrings.sql367 SELECT 'hawkeye' ILIKE 'h%' AS "true";
368 SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
370 SELECT 'hawkeye' ILIKE 'H%' AS "true";
371 SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
373 SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
374 SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
376 SELECT 'Hawkeye' ILIKE 'h%' AS "true";
377 SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";
379 SELECT 'ABC'::name ILIKE '_b_' AS "true";
380 SELECT 'ABC'::name NOT ILIKE '_b_' AS "false";
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/
H A Dstrings.sql367 SELECT 'hawkeye' ILIKE 'h%' AS "true";
368 SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
370 SELECT 'hawkeye' ILIKE 'H%' AS "true";
371 SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
373 SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
374 SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
376 SELECT 'Hawkeye' ILIKE 'h%' AS "true";
377 SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";
379 SELECT 'ABC'::name ILIKE '_b_' AS "true";
380 SELECT 'ABC'::name NOT ILIKE '_b_' AS "false";
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/
H A Dstrings.sql367 SELECT 'hawkeye' ILIKE 'h%' AS "true";
368 SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
370 SELECT 'hawkeye' ILIKE 'H%' AS "true";
371 SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
373 SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
374 SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
376 SELECT 'Hawkeye' ILIKE 'h%' AS "true";
377 SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";
379 SELECT 'ABC'::name ILIKE '_b_' AS "true";
380 SELECT 'ABC'::name NOT ILIKE '_b_' AS "false";
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/
H A Dstrings.sql367 SELECT 'hawkeye' ILIKE 'h%' AS "true";
368 SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
370 SELECT 'hawkeye' ILIKE 'H%' AS "true";
371 SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
373 SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
374 SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
376 SELECT 'Hawkeye' ILIKE 'h%' AS "true";
377 SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";
379 SELECT 'ABC'::name ILIKE '_b_' AS "true";
380 SELECT 'ABC'::name NOT ILIKE '_b_' AS "false";
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/
H A Dstrings.sql367 SELECT 'hawkeye' ILIKE 'h%' AS "true";
368 SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
370 SELECT 'hawkeye' ILIKE 'H%' AS "true";
371 SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
373 SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
374 SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
376 SELECT 'Hawkeye' ILIKE 'h%' AS "true";
377 SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";
379 SELECT 'ABC'::name ILIKE '_b_' AS "true";
380 SELECT 'ABC'::name NOT ILIKE '_b_' AS "false";
/dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/sql/
H A Dstrings.sql367 SELECT 'hawkeye' ILIKE 'h%' AS "true";
368 SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
370 SELECT 'hawkeye' ILIKE 'H%' AS "true";
371 SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
373 SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
374 SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
376 SELECT 'Hawkeye' ILIKE 'h%' AS "true";
377 SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";
379 SELECT 'ABC'::name ILIKE '_b_' AS "true";
380 SELECT 'ABC'::name NOT ILIKE '_b_' AS "false";
/dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/sql/
H A Dstrings.sql367 SELECT 'hawkeye' ILIKE 'h%' AS "true";
368 SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
370 SELECT 'hawkeye' ILIKE 'H%' AS "true";
371 SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
373 SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
374 SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
376 SELECT 'Hawkeye' ILIKE 'h%' AS "true";
377 SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";
379 SELECT 'ABC'::name ILIKE '_b_' AS "true";
380 SELECT 'ABC'::name NOT ILIKE '_b_' AS "false";
/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/
H A Dstrings.sql301 SELECT 'hawkeye' ILIKE 'h%' AS "true";
302 SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
304 SELECT 'hawkeye' ILIKE 'H%' AS "true";
305 SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
307 SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
308 SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
310 SELECT 'Hawkeye' ILIKE 'h%' AS "true";
311 SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/
H A Dstrings.sql301 SELECT 'hawkeye' ILIKE 'h%' AS "true";
302 SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
304 SELECT 'hawkeye' ILIKE 'H%' AS "true";
305 SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
307 SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
308 SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
310 SELECT 'Hawkeye' ILIKE 'h%' AS "true";
311 SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/
H A Dstrings.sql301 SELECT 'hawkeye' ILIKE 'h%' AS "true";
302 SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
304 SELECT 'hawkeye' ILIKE 'H%' AS "true";
305 SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
307 SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
308 SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
310 SELECT 'Hawkeye' ILIKE 'h%' AS "true";
311 SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/
H A Dstrings.sql301 SELECT 'hawkeye' ILIKE 'h%' AS "true";
302 SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
304 SELECT 'hawkeye' ILIKE 'H%' AS "true";
305 SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
307 SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
308 SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
310 SELECT 'Hawkeye' ILIKE 'h%' AS "true";
311 SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/
H A Dstrings.sql301 SELECT 'hawkeye' ILIKE 'h%' AS "true";
302 SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
304 SELECT 'hawkeye' ILIKE 'H%' AS "true";
305 SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
307 SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
308 SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
310 SELECT 'Hawkeye' ILIKE 'h%' AS "true";
311 SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/
H A Dstrings.sql301 SELECT 'hawkeye' ILIKE 'h%' AS "true";
302 SELECT 'hawkeye' NOT ILIKE 'h%' AS "false";
304 SELECT 'hawkeye' ILIKE 'H%' AS "true";
305 SELECT 'hawkeye' NOT ILIKE 'H%' AS "false";
307 SELECT 'hawkeye' ILIKE 'H%Eye' AS "true";
308 SELECT 'hawkeye' NOT ILIKE 'H%Eye' AS "false";
310 SELECT 'Hawkeye' ILIKE 'h%' AS "true";
311 SELECT 'Hawkeye' NOT ILIKE 'h%' AS "false";

12345678910>>...61