From 535e6322944cd1e1776ebd06b43ff305e71f022b Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 8 Nov 2010 19:00:57 +0000 Subject: [PATCH] Bacport r18657: syntax problem spotted by Jason Etheridge git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_2_0@18658 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/012.schema.vandelay.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/0461.schema.vandelay.replace_field.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql index 14ddb5f827..9ca76805e1 100644 --- a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql +++ b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql @@ -379,7 +379,7 @@ CREATE OR REPLACE FUNCTION vandelay.add_field ( target_xml TEXT, source_xml TEXT $_$ LANGUAGE PLPERLU; CREATE OR REPLACE FUNCTION vandelay.add_field ( target_xml TEXT, source_xml TEXT, field TEXT ) RETURNS TEXT AS $_$ - SELECT vandelay.add_field( $1, $2 $3, 0 ); + SELECT vandelay.add_field( $1, $2, $3, 0 ); $_$ LANGUAGE SQL; CREATE OR REPLACE FUNCTION vandelay.strip_field ( xml TEXT, field TEXT ) RETURNS TEXT AS $_$ diff --git a/Open-ILS/src/sql/Pg/upgrade/0461.schema.vandelay.replace_field.sql b/Open-ILS/src/sql/Pg/upgrade/0461.schema.vandelay.replace_field.sql index ff5c362be3..2e47ec26e0 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0461.schema.vandelay.replace_field.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0461.schema.vandelay.replace_field.sql @@ -77,7 +77,7 @@ CREATE OR REPLACE FUNCTION vandelay.add_field ( target_xml TEXT, source_xml TEXT $_$ LANGUAGE PLPERLU; CREATE OR REPLACE FUNCTION vandelay.add_field ( target_xml TEXT, source_xml TEXT, field TEXT ) RETURNS TEXT AS $_$ - SELECT vandelay.add_field( $1, $2 $3, 0 ); + SELECT vandelay.add_field( $1, $2, $3, 0 ); $_$ LANGUAGE SQL; CREATE OR REPLACE FUNCTION vandelay.replace_field ( target_xml TEXT, source_xml TEXT, field TEXT ) RETURNS TEXT AS $_$ -- 2.11.0