/dports/databases/postgis32/postgis-3.2.0/extras/tiger_geocoder/geocode/ |
H A D | geocode_address.sql | 45 WHERE zc.statefp = ' || quote_nullable(in_statefp) || ' 66 RAISE NOTICE 'Bad zip newzip range: %', quote_nullable(zip_info.zip); 187 quote_nullable(parsed.location)), '$4', quote_nullable(parsed.streetTypeAbbrev) ), 188 '$5', quote_nullable(parsed.preDirAbbrev) ), 189 '$6', quote_nullable(parsed.postDirAbbrev) ), 190 '$7', quote_nullable(parsed.zip) ), 191 '$8', quote_nullable(var_restrict_geom::text) ), 192 '$9', quote_nullable(zip_info.zip) ), '$1', quote_nullable(parsed.address) ); 261 …AND (' || quote_nullable(in_statefp) || ' IS NULL OR zip_state.statefp = ' || quote_nullable(in_st… 265 WHERE zip_state_loc.statefp = ' || quote_nullable(in_statefp) || ' [all …]
|
H A D | geocode_intersection.sql | 53 RAISE NOTICE 'var_zip: %, city: %', quote_nullable(var_zip), quote_nullable(in_city); 122 replace(var_sql, '$1', quote_nullable(in_statefp)), 123 '$2', quote_nullable(lower(var_na_road.streetName) ) ), 124 '$3', quote_nullable(lower(in_city)) ), 125 '$4', quote_nullable(lower(var_na_inter1.streetName) ) ), 126 '$5', quote_nullable(var_zip) ), 127 …'$6', quote_nullable(lower(var_na_road.streetName || ' ' || COALESCE(var_na_road.streetTypeAbbrev,… 128 …'$7', quote_nullable(trim(lower(var_na_inter1.streetName || ' ' || COALESCE(var_na_inter1.streetTy… 129 '$8', quote_nullable(in_state ) ), '$9', num_results::text );
|
/dports/databases/postgis31/postgis-3.1.4/extras/tiger_geocoder/geocode/ |
H A D | geocode_address.sql | 45 WHERE zc.statefp = ' || quote_nullable(in_statefp) || ' 66 RAISE NOTICE 'Bad zip newzip range: %', quote_nullable(zip_info.zip); 187 quote_nullable(parsed.location)), '$4', quote_nullable(parsed.streetTypeAbbrev) ), 188 '$5', quote_nullable(parsed.preDirAbbrev) ), 189 '$6', quote_nullable(parsed.postDirAbbrev) ), 190 '$7', quote_nullable(parsed.zip) ), 191 '$8', quote_nullable(var_restrict_geom::text) ), 192 '$9', quote_nullable(zip_info.zip) ), '$1', quote_nullable(parsed.address) ); 261 …AND (' || quote_nullable(in_statefp) || ' IS NULL OR zip_state.statefp = ' || quote_nullable(in_st… 265 WHERE zip_state_loc.statefp = ' || quote_nullable(in_statefp) || ' [all …]
|
H A D | geocode_intersection.sql | 53 RAISE NOTICE 'var_zip: %, city: %', quote_nullable(var_zip), quote_nullable(in_city); 122 replace(var_sql, '$1', quote_nullable(in_statefp)), 123 '$2', quote_nullable(lower(var_na_road.streetName) ) ), 124 '$3', quote_nullable(lower(in_city)) ), 125 '$4', quote_nullable(lower(var_na_inter1.streetName) ) ), 126 '$5', quote_nullable(var_zip) ), 127 …'$6', quote_nullable(lower(var_na_road.streetName || ' ' || COALESCE(var_na_road.streetTypeAbbrev,… 128 …'$7', quote_nullable(trim(lower(var_na_inter1.streetName || ' ' || COALESCE(var_na_inter1.streetTy… 129 '$8', quote_nullable(in_state ) ), '$9', num_results::text );
|
/dports/databases/postgis30/postgis-3.0.4/extras/tiger_geocoder/geocode/ |
H A D | geocode_address.sql | 45 WHERE zc.statefp = ' || quote_nullable(in_statefp) || ' 66 RAISE NOTICE 'Bad zip newzip range: %', quote_nullable(zip_info.zip); 187 quote_nullable(parsed.location)), '$4', quote_nullable(parsed.streetTypeAbbrev) ), 188 '$5', quote_nullable(parsed.preDirAbbrev) ), 189 '$6', quote_nullable(parsed.postDirAbbrev) ), 190 '$7', quote_nullable(parsed.zip) ), 191 '$8', quote_nullable(var_restrict_geom::text) ), 192 '$9', quote_nullable(zip_info.zip) ), '$1', quote_nullable(parsed.address) ); 261 …AND (' || quote_nullable(in_statefp) || ' IS NULL OR zip_state.statefp = ' || quote_nullable(in_st… 265 WHERE zip_state_loc.statefp = ' || quote_nullable(in_statefp) || ' [all …]
|
H A D | geocode_intersection.sql | 53 RAISE NOTICE 'var_zip: %, city: %', quote_nullable(var_zip), quote_nullable(in_city); 122 replace(var_sql, '$1', quote_nullable(in_statefp)), 123 '$2', quote_nullable(lower(var_na_road.streetName) ) ), 124 '$3', quote_nullable(lower(in_city)) ), 125 '$4', quote_nullable(lower(var_na_inter1.streetName) ) ), 126 '$5', quote_nullable(var_zip) ), 127 …'$6', quote_nullable(lower(var_na_road.streetName || ' ' || COALESCE(var_na_road.streetTypeAbbrev,… 128 …'$7', quote_nullable(trim(lower(var_na_inter1.streetName || ' ' || COALESCE(var_na_inter1.streetTy… 129 '$8', quote_nullable(in_state ) ), '$9', num_results::text );
|
/dports/databases/postgis25/postgis-2.5.5/extras/tiger_geocoder/geocode/ |
H A D | geocode_address.sql | 45 WHERE zc.statefp = ' || quote_nullable(in_statefp) || ' 66 RAISE NOTICE 'Bad zip newzip range: %', quote_nullable(zip_info.zip); 187 quote_nullable(parsed.location)), '$4', quote_nullable(parsed.streetTypeAbbrev) ), 188 '$5', quote_nullable(parsed.preDirAbbrev) ), 189 '$6', quote_nullable(parsed.postDirAbbrev) ), 190 '$7', quote_nullable(parsed.zip) ), 191 '$8', quote_nullable(var_restrict_geom::text) ), 192 '$9', quote_nullable(zip_info.zip) ), '$1', quote_nullable(parsed.address) ); 261 …AND (' || quote_nullable(in_statefp) || ' IS NULL OR zip_state.statefp = ' || quote_nullable(in_st… 265 WHERE zip_state_loc.statefp = ' || quote_nullable(in_statefp) || ' [all …]
|
H A D | geocode_intersection.sql | 53 RAISE NOTICE 'var_zip: %, city: %', quote_nullable(var_zip), quote_nullable(in_city); 122 replace(var_sql, '$1', quote_nullable(in_statefp)), 123 '$2', quote_nullable(lower(var_na_road.streetName) ) ), 124 '$3', quote_nullable(lower(in_city)) ), 125 '$4', quote_nullable(lower(var_na_inter1.streetName) ) ), 126 '$5', quote_nullable(var_zip) ), 127 …'$6', quote_nullable(lower(var_na_road.streetName || ' ' || COALESCE(var_na_road.streetTypeAbbrev,… 128 …'$7', quote_nullable(trim(lower(var_na_inter1.streetName || ' ' || COALESCE(var_na_inter1.streetTy… 129 '$8', quote_nullable(in_state ) ), '$9', num_results::text );
|
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/pl/plperl/ |
H A D | plc_perlboot.pl | 44 return ::quote_nullable($arg) unless ::is_array_ref($arg); 46 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql96-server/postgresql-9.6.24/src/pl/plperl/ |
H A D | plc_perlboot.pl | 44 return ::quote_nullable($arg) unless ::is_array_ref($arg); 46 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/pl/plperl/ |
H A D | plc_perlboot.pl | 44 return ::quote_nullable($arg) unless ::is_array_ref($arg); 46 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/pl/plperl/ |
H A D | plc_perlboot.pl | 44 return ::quote_nullable($arg) unless ::is_array_ref($arg); 46 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql10-docs/postgresql-10.19/src/pl/plperl/ |
H A D | plc_perlboot.pl | 46 return ::quote_nullable($arg) unless ::is_array_ref($arg); 48 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql11-client/postgresql-11.14/src/pl/plperl/ |
H A D | plc_perlboot.pl | 46 return ::quote_nullable($arg) unless ::is_array_ref($arg); 48 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql10-server/postgresql-10.19/src/pl/plperl/ |
H A D | plc_perlboot.pl | 46 return ::quote_nullable($arg) unless ::is_array_ref($arg); 48 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/pl/plperl/ |
H A D | plc_perlboot.pl | 46 return ::quote_nullable($arg) unless ::is_array_ref($arg); 48 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql10-contrib/postgresql-10.19/src/pl/plperl/ |
H A D | plc_perlboot.pl | 46 return ::quote_nullable($arg) unless ::is_array_ref($arg); 48 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql10-client/postgresql-10.19/src/pl/plperl/ |
H A D | plc_perlboot.pl | 46 return ::quote_nullable($arg) unless ::is_array_ref($arg); 48 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql10-plpython/postgresql-10.19/src/pl/plperl/ |
H A D | plc_perlboot.pl | 46 return ::quote_nullable($arg) unless ::is_array_ref($arg); 48 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql10-plperl/postgresql-10.19/src/pl/plperl/ |
H A D | plc_perlboot.pl | 46 return ::quote_nullable($arg) unless ::is_array_ref($arg); 48 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql11-plperl/postgresql-11.14/src/pl/plperl/ |
H A D | plc_perlboot.pl | 46 return ::quote_nullable($arg) unless ::is_array_ref($arg); 48 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql11-contrib/postgresql-11.14/src/pl/plperl/ |
H A D | plc_perlboot.pl | 46 return ::quote_nullable($arg) unless ::is_array_ref($arg); 48 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql11-docs/postgresql-11.14/src/pl/plperl/ |
H A D | plc_perlboot.pl | 46 return ::quote_nullable($arg) unless ::is_array_ref($arg); 48 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql11-server/postgresql-11.14/src/pl/plperl/ |
H A D | plc_perlboot.pl | 46 return ::quote_nullable($arg) unless ::is_array_ref($arg); 48 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/pl/plperl/ |
H A D | plc_perlboot.pl | 46 return ::quote_nullable($arg) unless ::is_array_ref($arg); 48 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }
|