From c864ee7f9147c36d48ee95ee3b7c8f0f080b9186 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Wed, 14 Dec 2011 13:48:22 -0500 Subject: [PATCH] Fix type conflict in unapi.circ Due to the change in positional arguments, $2 is now $9; thankfully PostgreSQL complained about the difference in types. Maybe an argument for using argument names instead of positional identifiers? :) Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/990.schema.unapi.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/990.schema.unapi.sql b/Open-ILS/src/sql/Pg/990.schema.unapi.sql index 4f8dd0443f..2e542dd326 100644 --- a/Open-ILS/src/sql/Pg/990.schema.unapi.sql +++ b/Open-ILS/src/sql/Pg/990.schema.unapi.sql @@ -971,7 +971,7 @@ CREATE OR REPLACE FUNCTION unapi.circ (obj_id BIGINT, format TEXT, ename TEXT, i SELECT XMLELEMENT( name circ, XMLATTRIBUTES( - CASE WHEN $2 THEN 'http://open-ils.org/spec/holdings/v1' ELSE NULL END AS xmlns, + CASE WHEN $9 THEN 'http://open-ils.org/spec/holdings/v1' ELSE NULL END AS xmlns, 'tag:open-ils.org:U2@circ/' || id AS id, xact_start, due_date -- 2.11.0