From c6f8b7aca88e8145c5bd372a0d3fd402529e9ed5 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sat, 18 Jun 2011 07:35:26 +0000 Subject: [PATCH] hmm lets try that again git-svn-id: http://svn.osgeo.org/postgis/trunk@7424 b70326c6-7e19-0410-871a-916f4a2858ee --- .../tiger_2010/geocode/other_helper_functions.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/extras/tiger_geocoder/tiger_2010/geocode/other_helper_functions.sql b/extras/tiger_geocoder/tiger_2010/geocode/other_helper_functions.sql index 5dd4e05c8..7d7d953d6 100644 --- a/extras/tiger_geocoder/tiger_2010/geocode/other_helper_functions.sql +++ b/extras/tiger_geocoder/tiger_2010/geocode/other_helper_functions.sql @@ -9,7 +9,7 @@ -- and least(to_number(b.fromhn,''99999999''),to_number(b.tohn,''99999999'')) CREATE OR REPLACE FUNCTION least_hn(fromhn varchar, tohn varchar) RETURNS integer AS -$$ SELECT least(to_number( CASE WHEN trim($1) ~ '^[0-9]+$' THEN $1 ELSE '0' END,'9999999'),to_number(CASE WHEN trim($2) ~ '^[0-9.]+$' THEN $2 ELSE '0' END,'9999999') )::integer; $$ +$$ SELECT least(to_number( CASE WHEN trim($1) ~ '^[0-9]+$' THEN $1 ELSE '0' END,'9999999'),to_number(CASE WHEN trim($2) ~ '^[0-9]+$' THEN $2 ELSE '0' END,'9999999') )::integer; $$ LANGUAGE sql IMMUTABLE COST 5; -- 2.50.1