From 7ec5c403dcff7ba93bda96a3a0fdb3396fbdbdc1 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Thu, 7 Sep 2017 05:51:03 +0000 Subject: [PATCH] fix field typo in reverse_geocoder Closes #3833 for PostGIS 2.3.4 git-svn-id: http://svn.osgeo.org/postgis/branches/2.3@15645 b70326c6-7e19-0410-871a-916f4a2858ee --- extras/tiger_geocoder/geocode/reverse_geocode.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/extras/tiger_geocoder/geocode/reverse_geocode.sql b/extras/tiger_geocoder/geocode/reverse_geocode.sql index 9f0053652..5a103de1a 100644 --- a/extras/tiger_geocoder/geocode/reverse_geocode.sql +++ b/extras/tiger_geocoder/geocode/reverse_geocode.sql @@ -211,7 +211,7 @@ BEGIN var_addy_alt.streetname := var_addy.streetname; var_addy_alt.streettypeabbrev := var_addy.streettypeabbrev; var_addy_alt.predirabbrev := var_addy.predirabbrev; - var_addy_alt.postDirAbbrev := var_addy.sufdirabrv; + var_addy_alt.postDirAbbrev := var_addy.postDirAbbrev; addy[array_upper(addy,1) - 1 ] := var_addy_alt; IF var_debug THEN RAISE NOTICE 'Replaced with : %, %', var_addy_alt, clock_timestamp(); -- 2.49.0