From 47d3516f579f3d925dd06272ab807bf034971f49 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 9fff1ca9dc..a29f96d3d7 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