From 5fe2e05653bf99cbb83768b9d6bee924ccad3e7e Mon Sep 17 00:00:00 2001
From: Regina Obe <lr@pcorp.us>
Date: Sun, 5 Jun 2011 07:35:14 +0000
Subject: [PATCH] more speed optimizations

git-svn-id: http://svn.osgeo.org/postgis/trunk@7323 b70326c6-7e19-0410-871a-916f4a2858ee
---
 extras/tiger_geocoder/tiger_2010/geocode/geocode_address.sql  | 4 ++--
 .../tiger_2010/geocode/interpolate_from_address.sql           | 2 +-
 extras/tiger_geocoder/tiger_2010/geocode/rate_attributes.sql  | 4 ++--
 3 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/extras/tiger_geocoder/tiger_2010/geocode/geocode_address.sql b/extras/tiger_geocoder/tiger_2010/geocode/geocode_address.sql
index 27e6d13a0..7fe3b883a 100644
--- a/extras/tiger_geocoder/tiger_2010/geocode/geocode_address.sql
+++ b/extras/tiger_geocoder/tiger_2010/geocode/geocode_address.sql
@@ -78,8 +78,8 @@ BEGIN
          || '            THEN 2'
          || '        ELSE'
          || '            ((1.0 - '
-         ||              '(least(' || coalesce(quote_literal(parsed.address || '.0'),'NULL') || '::numeric,to_number(b.fromhn,''99999999''),to_number(b.tohn,''99999999'')) /'
-         ||              ' greatest(' || coalesce(quote_literal(parsed.address || '.0'),'NULL') || '::numeric,to_number(b.fromhn,''99999999''),to_number(b.tohn,''99999999'')))'
+         ||              '(least_hn(' || coalesce(quote_literal(parsed.address || '.0'),'NULL') || ',least_hn(b.fromhn,b.tohn)::text) /'
+         ||              ' greatest_hn(' || coalesce(quote_literal(parsed.address || '.0'),'NULL') || ',greatest_hn(b.fromhn,b.tohn)::text))'
          ||              ') * 5)::integer + 5'
          || '        END'
          || '    as sub_rating,'
diff --git a/extras/tiger_geocoder/tiger_2010/geocode/interpolate_from_address.sql b/extras/tiger_geocoder/tiger_2010/geocode/interpolate_from_address.sql
index e0fc43474..9537cb444 100644
--- a/extras/tiger_geocoder/tiger_2010/geocode/interpolate_from_address.sql
+++ b/extras/tiger_geocoder/tiger_2010/geocode/interpolate_from_address.sql
@@ -55,4 +55,4 @@ BEGIN
     result = ST_Line_Interpolate_Point(road, part);
     RETURN result;
 END;
-$_$ LANGUAGE plpgsql IMMUTABLE COST 100;
+$_$ LANGUAGE plpgsql IMMUTABLE COST 10;
diff --git a/extras/tiger_geocoder/tiger_2010/geocode/rate_attributes.sql b/extras/tiger_geocoder/tiger_2010/geocode/rate_attributes.sql
index 54e9debbf..187ac4a93 100644
--- a/extras/tiger_geocoder/tiger_2010/geocode/rate_attributes.sql
+++ b/extras/tiger_geocoder/tiger_2010/geocode/rate_attributes.sql
@@ -24,7 +24,7 @@ BEGIN
   result := result + rate_attributes($1, $2, $3, $4, $5, $6, $7, $8);
   RETURN result;
 END;
-$_$ LANGUAGE plpgsql;
+$_$ LANGUAGE plpgsql IMMUTABLE;
 
 -- rate_attributes(dirpA, dirpB, streetNameA, streetNameB, streetTypeA,
 -- streetTypeB, dirsA, dirsB)
@@ -57,4 +57,4 @@ BEGIN
       directionWeight;
   return result;
 END;
-$_$ LANGUAGE plpgsql STABLE COST 10;
+$_$ LANGUAGE plpgsql IMMUTABLE;
-- 
2.50.1