From a45269371b7a18dcb6c0c7e14ee97be46d69871e Mon Sep 17 00:00:00 2001
From: Regina Obe <lr@pcorp.us>
Date: Sun, 23 Aug 2015 05:47:21 +0000
Subject: [PATCH] make pre_type check not case sensitive

git-svn-id: http://svn.osgeo.org/postgis/trunk@13980 b70326c6-7e19-0410-871a-916f4a2858ee
---
 extras/tiger_geocoder/normalize/pprint_addy.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/extras/tiger_geocoder/normalize/pprint_addy.sql b/extras/tiger_geocoder/normalize/pprint_addy.sql
index 558d27ffa..7d0f2d854 100644
--- a/extras/tiger_geocoder/normalize/pprint_addy.sql
+++ b/extras/tiger_geocoder/normalize/pprint_addy.sql
@@ -5,7 +5,7 @@
 -- it applies to foreign influenced roads like Camino (for road)
 CREATE OR REPLACE FUNCTION is_pretype(text) RETURNS boolean AS
 $$
-    SELECT EXISTS(SELECT name FROM street_type_lookup WHERE name = upper($1) AND is_hw );
+    SELECT EXISTS(SELECT name FROM street_type_lookup WHERE upper(name) = upper($1) AND is_hw );
 $$
 LANGUAGE sql IMMUTABLE STRICT; /** I know this should be stable but it's practically immutable :) **/
 
-- 
2.40.0