From 2561f0fa5ebab57fef121991a10beb0af4072c9f Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 5 Jun 2017 11:22:52 -0400 Subject: [PATCH] JBAS-1554 Custom purge circs SQL params repair Update action.purge_circulations_custom definition to include the start and end time function parameters to ensure the existing function is replaced instead of creating a new function. Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/patron-co-history-stage-2.sql | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/KCLS/sql/schema/deploy/patron-co-history-stage-2.sql b/KCLS/sql/schema/deploy/patron-co-history-stage-2.sql index 5ad499653b..716b7c0a9a 100644 --- a/KCLS/sql/schema/deploy/patron-co-history-stage-2.sql +++ b/KCLS/sql/schema/deploy/patron-co-history-stage-2.sql @@ -111,10 +111,9 @@ $$; -- NOTE: ^-- stock CSV template does not include checkin_time, so -- no modifications are required. -CREATE OR REPLACE FUNCTION action.purge_circulations_custom () RETURNS INT AS $func$ +CREATE OR REPLACE FUNCTION action.purge_circulations_custom + (in_time_start TIMESTAMPTZ, in_time_end TIMESTAMPTZ) RETURNS INT AS $func$ DECLARE - usr_keep_age actor.usr_setting%ROWTYPE; - usr_keep_start actor.usr_setting%ROWTYPE; org_keep_age INTERVAL; org_use_last BOOL = false; org_age_is_min BOOL = false; -- 2.11.0