From b129249642bd602b03bb20fce426f30c22aa03e6 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Tue, 11 Aug 2009 10:39:15 +0000 Subject: [PATCH] this stored procedure is a true function with no side effects --- sql/base/base.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index f8c68e8..832f43c 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -258,7 +258,7 @@ CREATE OR REPLACE FUNCTION migration_tools.name_parse_out_last_comma_prefix_firs RETURN ARRAY[ family_name, prefix, first_given_name, second_given_name, suffix ]; END; -$$ LANGUAGE PLPGSQL STRICT VOLATILE; +$$ LANGUAGE PLPGSQL STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION migration_tools.address_parse_out_citystatezip (TEXT) RETURNS TEXT[] AS $$ DECLARE -- 1.7.2.5