Wrapper functions in the baseline schema that were missed in the upgrade script
authorMike Rylander <mrylander@gmail.com>
Fri, 7 Oct 2011 20:22:42 +0000 (16:22 -0400)
committerBill Erickson <berick@esilibrary.com>
Fri, 14 Oct 2011 18:21:38 +0000 (14:21 -0400)
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Bill Erickson <berick@esilibrary.com>

Open-ILS/src/sql/Pg/upgrade/XXXX.schema-acs-nfi.sql

index 1e5e85a..86b2ec4 100644 (file)
@@ -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,