From 1f6182ce6b3754390a1a0b4d04805234c2b94fb8 Mon Sep 17 00:00:00 2001 From: Thomas Berezansky Date: Mon, 18 Jun 2012 12:49:39 -0400 Subject: [PATCH] Circ Chain Functions should take BIGINTs Because INTEGER isn't suitable for circ IDs. This only requires editing the input definitions. Signed-off-by: Thomas Berezansky --- Open-ILS/src/sql/Pg/090.schema.action.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index 1af6e89ead..50d193e1ad 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -576,7 +576,7 @@ CREATE TYPE action.circ_chain_summary AS ( ); -CREATE OR REPLACE FUNCTION action.circ_chain ( ctx_circ_id INTEGER ) RETURNS SETOF action.circulation AS $$ +CREATE OR REPLACE FUNCTION action.circ_chain ( ctx_circ_id BIGINT ) RETURNS SETOF action.circulation AS $$ DECLARE tmp_circ action.circulation%ROWTYPE; circ_0 action.circulation%ROWTYPE; @@ -611,7 +611,7 @@ BEGIN END; $$ LANGUAGE 'plpgsql'; -CREATE OR REPLACE FUNCTION action.summarize_circ_chain ( ctx_circ_id INTEGER ) RETURNS action.circ_chain_summary AS $$ +CREATE OR REPLACE FUNCTION action.summarize_circ_chain ( ctx_circ_id BIGINT ) RETURNS action.circ_chain_summary AS $$ DECLARE -- 2.11.0