From f04a8cd2853427861e68c9bcfeb26bdcb134d1b2 Mon Sep 17 00:00:00 2001 From: dbs Date: Mon, 13 Apr 2009 04:17:39 +0000 Subject: [PATCH] context_org_list is an array, and PostgreSQL 8.3 wants it declared as such git-svn-id: svn://svn.open-ils.org/ILS/trunk@12848 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/110.hold_matrix.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/110.hold_matrix.sql b/Open-ILS/src/sql/Pg/110.hold_matrix.sql index 39aa4137e0..d526830d5c 100644 --- a/Open-ILS/src/sql/Pg/110.hold_matrix.sql +++ b/Open-ILS/src/sql/Pg/110.hold_matrix.sql @@ -179,7 +179,7 @@ DECLARE hold_count INT; hold_transit_prox INT; frozen_hold_count INT; - context_org_list INT; + context_org_list INT[]; done BOOL := FALSE; BEGIN SELECT INTO user_object * FROM actor.usr WHERE id = match_user; -- 2.11.0