From 2507bd098ddaf7d87d9d6035fb0ab904be6c967d Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 24 Jun 2010 18:51:57 +0000 Subject: [PATCH] doh, another thinko. spotted by Scott McKellar git-svn-id: svn://svn.open-ils.org/ILS/trunk@16809 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/020.schema.functions.sql | 4 ++-- .../sql/Pg/upgrade/0315.data.authority-related-index-normalizers.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/Open-ILS/src/sql/Pg/020.schema.functions.sql b/Open-ILS/src/sql/Pg/020.schema.functions.sql index 29d2d6a6e6..6c6738561c 100644 --- a/Open-ILS/src/sql/Pg/020.schema.functions.sql +++ b/Open-ILS/src/sql/Pg/020.schema.functions.sql @@ -100,9 +100,9 @@ CREATE OR REPLACE FUNCTION public.remove_commas( TEXT ) RETURNS TEXT AS $$ SELECT regexp_replace($1, ',', '', 'g'); $$ LANGUAGE SQL STRICT IMMUTABLE; -CREATE OR REPLACE FUNCTION public.remove_paren_substring( TEXT ) RETURNS TEXT AS $$ +CREATE OR REPLACE FUNCTION public.remove_paren_substring( TEXT ) RETURNS TEXT AS $func$ SELECT regexp_replace($1, $$\([^)]+\)$$, '', 'g'); -$$ LANGUAGE SQL STRICT IMMUTABLE; +$func$ LANGUAGE SQL STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION public.remove_whitespace( TEXT ) RETURNS TEXT AS $$ SELECT regexp_replace(normalize_space($1), E'\\s+', '', 'g'); diff --git a/Open-ILS/src/sql/Pg/upgrade/0315.data.authority-related-index-normalizers.sql b/Open-ILS/src/sql/Pg/upgrade/0315.data.authority-related-index-normalizers.sql index e0450758fc..ad1b37eaba 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0315.data.authority-related-index-normalizers.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0315.data.authority-related-index-normalizers.sql @@ -2,9 +2,9 @@ BEGIN; INSERT INTO config.upgrade_log (version) VALUES ('0315'); --miker -CREATE OR REPLACE FUNCTION public.remove_paren_substring( TEXT ) RETURNS TEXT AS $$ +CREATE OR REPLACE FUNCTION public.remove_paren_substring( TEXT ) RETURNS TEXT AS $func$ SELECT regexp_replace($1, $$\([^)]+\)$$, '', 'g'); -$$ LANGUAGE SQL STRICT IMMUTABLE; +$func$ LANGUAGE SQL STRICT IMMUTABLE; INSERT INTO config.metabib_field ( id, field_class, name, label, format, xpath, facet_field, search_field ) VALUES (26, 'identifier', 'arcn', oils_i18n_gettext(26, 'Authority record control number', 'cmf', 'label'), 'marcxml', $$//marc:subfield[@code='0']$$, TRUE, FALSE ); -- 2.11.0