From 861688704ecd2810b6f2e04500331a08e2042c69 Mon Sep 17 00:00:00 2001 From: dbs Date: Fri, 18 Mar 2011 18:38:38 +0000 Subject: [PATCH] Use RETURNS SETOF record and OUT params to support older PostgreSQL Specifically, PostgreSQL 8.3 doesn't have RETURNS TABLE support. Waah. git-svn-id: svn://svn.open-ils.org/ILS-Contrib/conifer/branches/rel_1_6_1@1268 6d9bc8c9-1ec2-4278-b937-99fde70a366f --- src/sql/Pg/solr.sql | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) diff --git a/src/sql/Pg/solr.sql b/src/sql/Pg/solr.sql index 921cbed809..fc37f6a4c6 100644 --- a/src/sql/Pg/solr.sql +++ b/src/sql/Pg/solr.sql @@ -114,8 +114,14 @@ GRANT USAGE ON SCHEMA solr TO solr; GRANT SELECT ON TABLE solr.bib_updates TO solr; GRANT SELECT ON TABLE biblio.record_entry TO solr; -CREATE OR REPLACE FUNCTION solr.bib_updates_by_lib (since TIMESTAMP, libs INT[]) - RETURNS TABLE (record BIGINT, touch_type TEXT, touched TIMESTAMP) AS +CREATE OR REPLACE FUNCTION solr.bib_updates_by_lib ( + since TIMESTAMP, + libs INT[], + OUT record BIGINT, + OUT touch_type TEXT, + OUT touched TIMESTAMP +) + RETURNS SETOF record AS $bibs_by_lib$ SELECT DISTINCT bre.id, bre.marc, sbu.touched FROM biblio.record_entry bre -- 2.11.0