X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=sql%2Fbase%2F05-addresses.sql;fp=sql%2Fbase%2F05-addresses.sql;h=3f8fafde4ae48a57b218e1401815e44c8dc03d98;hp=45a2dcc408bd88863fa6a1b0286a66439470bcd2;hb=45dadf9e69e8ca838986d357406f456222ca55a2;hpb=ab57bcd894631f2952e28fca3ee548c6334fa6f1 diff --git a/sql/base/05-addresses.sql b/sql/base/05-addresses.sql index 45a2dcc..3f8fafd 100644 --- a/sql/base/05-addresses.sql +++ b/sql/base/05-addresses.sql @@ -21,7 +21,7 @@ CREATE OR REPLACE FUNCTION migration_tools.attempt_phone (TEXT,TEXT) RETURNS TEX $$ LANGUAGE PLPGSQL STRICT VOLATILE; -CREATE OR REPLACE FUNCTION msgration_tools.address_parse_out_citystatezip (TEXT) RETURNS TEXT[] AS $$ +CREATE OR REPLACE FUNCTION migration_tools.address_parse_out_citystatezip (TEXT) RETURNS TEXT[] AS $$ DECLARE city_state_zip TEXT := $1; city TEXT := '';