[postgis-tickets] r14898 - fix regexp mistake need to cast to text.

[Regina Obe]

Author: robe
Date: 2016-05-12 11:58:28 -0700 (Thu, 12 May 2016)
New Revision: 14898

Modified:
   branches/2.2/extras/tiger_geocoder/geocode/geocode_address.sql
Log:
fix regexp mistake need to cast to text.

Modified: branches/2.2/extras/tiger_geocoder/geocode/geocode_address.sql
===================================================================
--- branches/2.2/extras/tiger_geocoder/geocode/geocode_address.sql	2016-05-12 09:59:51 UTC (rev 14897)
+++ branches/2.2/extras/tiger_geocoder/geocode/geocode_address.sql	2016-05-12 18:58:28 UTC (rev 14898)
@@ -392,7 +392,7 @@
       END IF;
 
       IF results.exact_address THEN
-        ADDY.address := substring(parsed.address FROM '[0-9]+')::integer;
+        ADDY.address := substring(parsed.address::text FROM '[0-9]+')::integer;
       ELSE
         ADDY.address := NULL;
       END IF;