From 0ad6f0c0d28d530aff304c4f09483fb84a1d1fa0 Mon Sep 17 00:00:00 2001
From: Jason Stephenson <jstephenson@mvlc.org>
Date: Thu, 3 Oct 2013 16:43:50 -0400
Subject: [PATCH] Drop old evergreen.ranked_volumes() function in upgrade
 script.

This becomes necessary because the function input parameters were renamed
to avoid clashes with other variables and/or column names.
---
 .../src/sql/Pg/upgrade/XXXX.function.ranked_volumes.sql    | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.ranked_volumes.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.function.ranked_volumes.sql
index c5e5026e26..8d228b9a98 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.ranked_volumes.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.function.ranked_volumes.sql
@@ -1,3 +1,15 @@
+BEGIN;
+
+DROP FUNCTION evergreen.ranked_volumes(
+    bibid BIGINT, 
+    ouid INT,
+    depth INT,
+    slimit HSTORE,
+    soffset HSTORE,
+    pref_lib INT,
+    includes TEXT[]
+);
+
 CREATE OR REPLACE FUNCTION evergreen.ranked_volumes(
     p_bibid bigint,
     p_ouid integer,
@@ -100,3 +112,5 @@ BEGIN
     OFFSET (p_soffset -> 'acn')::INT;
 END;
 $_$;
+
+COMMIT;
-- 
2.11.0