Home
last modified time | relevance | path

Searched refs:quote_nullable (Results 1 – 25 of 619) sorted by relevance

12345678910>>...25

/dports/databases/postgis32/postgis-3.2.0/extras/tiger_geocoder/geocode/
H A Dgeocode_address.sql45 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 Dgeocode_intersection.sql53 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 Dgeocode_address.sql45 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 Dgeocode_intersection.sql53 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 Dgeocode_address.sql45 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 Dgeocode_intersection.sql53 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 Dgeocode_address.sql45 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 Dgeocode_intersection.sql53 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 Dplc_perlboot.pl44 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 Dplc_perlboot.pl44 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 Dplc_perlboot.pl44 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 Dplc_perlboot.pl44 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 Dplc_perlboot.pl46 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 Dplc_perlboot.pl46 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 Dplc_perlboot.pl46 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 Dplc_perlboot.pl46 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 Dplc_perlboot.pl46 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 Dplc_perlboot.pl46 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 Dplc_perlboot.pl46 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 Dplc_perlboot.pl46 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 Dplc_perlboot.pl46 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 Dplc_perlboot.pl46 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 Dplc_perlboot.pl46 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 Dplc_perlboot.pl46 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 Dplc_perlboot.pl46 return ::quote_nullable($arg) unless ::is_array_ref($arg);
48 map { (ref $_) ? ::encode_array_constructor($_) : ::quote_nullable($_) }

12345678910>>...25