/dports/graphics/qgis/qgis-3.22.3/resources/function_help/json/ |
H A D | ILIKE | 2 "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 D | ILIKE | 2 "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 D | normalize_address.sql | 258 …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 D | location_extract_place_exact.sql | 24 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 D | normalize_address.sql | 258 …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 D | location_extract_place_exact.sql | 24 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 D | normalize_address.sql | 258 …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 D | location_extract_place_exact.sql | 24 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 D | normalize_address.sql | 258 …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 D | location_extract_place_exact.sql | 24 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 D | isolation_citus_dist_activity.out | 35 …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 D | btree_index.sql | 128 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 D | strings.sql | 367 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 D | strings.sql | 367 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 D | strings.sql | 367 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 D | strings.sql | 367 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 D | strings.sql | 367 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 D | strings.sql | 367 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 D | strings.sql | 367 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 D | strings.sql | 301 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 D | strings.sql | 301 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 D | strings.sql | 301 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 D | strings.sql | 301 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 D | strings.sql | 301 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 D | strings.sql | 301 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";
|