From d5841c751e112b7eef890fdd30483c7791fcd49d Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Thu, 20 Aug 2015 19:29:18 +0000 Subject: [PATCH] #3161: treat nulls as blank text for rating purposes ( geocode_intersection returns a null rating for a specific intersection) git-svn-id: http://svn.osgeo.org/postgis/trunk@13958 b70326c6-7e19-0410-871a-916f4a2858ee --- extras/tiger_geocoder/utility/levenshtein_ignore_case.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/extras/tiger_geocoder/utility/levenshtein_ignore_case.sql b/extras/tiger_geocoder/utility/levenshtein_ignore_case.sql index 6447ae604..d0e832295 100644 --- a/extras/tiger_geocoder/utility/levenshtein_ignore_case.sql +++ b/extras/tiger_geocoder/utility/levenshtein_ignore_case.sql @@ -1,5 +1,5 @@ -- This function determines the levenshtein distance irespective of case. CREATE OR REPLACE FUNCTION levenshtein_ignore_case(VARCHAR, VARCHAR) RETURNS INTEGER AS $_$ - SELECT levenshtein(upper($1), upper($2)); + SELECT levenshtein(COALESCE(upper($1),''), COALESCE(upper($2),'')); $_$ LANGUAGE sql IMMUTABLE; -- 2.50.0