From 3f9b48c6caf9d5becf91a6226834a2e31054829b Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 8 Nov 2010 19:01:40 +0000 Subject: [PATCH] Bacport r18657: syntax problem spotted by Jason Etheridge git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6@18659 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 d7ec9ff31c..b742e3ddc4 100644 --- a/Open-ILS/src/sql/Pg/012.schema.vandelay.sql +++ b/Open-ILS/src/sql/Pg/012.schema.vandelay.sql @@ -262,7 +262,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 $_$ 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