From 40a4b6e6a7784eedd80c8ca968ee2316314f54d0 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Fri, 7 Oct 2011 16:22:42 -0400 Subject: [PATCH] Wrapper functions in the baseline schema that were missed in the upgrade script Signed-off-by: Mike Rylander Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema-acs-nfi.sql | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema-acs-nfi.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema-acs-nfi.sql index 1e5e85a984..86b2ec43d9 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema-acs-nfi.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema-acs-nfi.sql @@ -136,6 +136,14 @@ BEGIN END; $func$ LANGUAGE PLPGSQL IMMUTABLE; +CREATE OR REPLACE FUNCTION authority.simple_normalize_heading( marcxml TEXT ) RETURNS TEXT AS $func$ + SELECT authority.normalize_heading($1, TRUE); +$func$ LANGUAGE SQL IMMUTABLE; + +CREATE OR REPLACE FUNCTION authority.normalize_heading( marcxml TEXT ) RETURNS TEXT AS $func$ + SELECT authority.normalize_heading($1, FALSE); +$func$ LANGUAGE SQL IMMUTABLE; + CREATE TABLE authority.simple_heading ( id BIGSERIAL PRIMARY KEY, -- 2.43.2