From b370f8417c3ff48cba5577fa9cb04dbda3d24127 Mon Sep 17 00:00:00 2001 From: Thomas Berezansky Date: Wed, 19 Sep 2012 11:30:40 -0400 Subject: [PATCH] Return count purged Because postgres dislikes functions that don't return. Signed-off-by: Thomas Berezansky Signed-off-by: Jason Stephenson --- Open-ILS/src/sql/Pg/090.schema.action.sql | 2 ++ Open-ILS/src/sql/Pg/upgrade/XXXX.purge_circulations_updates.sql | 2 ++ 2 files changed, 4 insertions(+) diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index 51530e7936..80a7e0fda2 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -1070,6 +1070,8 @@ BEGIN END LOOP; END LOOP; + + return count_purged; END; $func$ LANGUAGE PLPGSQL; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.purge_circulations_updates.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.purge_circulations_updates.sql index 27dba650e3..7aaec706a1 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.purge_circulations_updates.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.purge_circulations_updates.sql @@ -200,6 +200,8 @@ BEGIN END LOOP; END LOOP; + + return count_purged; END; $func$ LANGUAGE PLPGSQL; -- 2.11.0