From a4c811aec22b0e1801e0b7ec2e51bab1a9b039b8 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 30 Dec 2013 13:14:11 -0500 Subject: [PATCH] fix return type of two collectionHQ functions The write_*_rows_to_stdout() functions return nothing, so set the return type accordingly to avoid "control reached end of function without RETURN" warnings. Signed-off-by: Galen Charlton --- collectionHQ/functions.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/collectionHQ/functions.sql b/collectionHQ/functions.sql index 1ebb6c2..0cea710 100644 --- a/collectionHQ/functions.sql +++ b/collectionHQ/functions.sql @@ -79,8 +79,8 @@ CREATE OR REPLACE FUNCTION collectionHQ.quote (TEXT) RETURNS TEXT AS $$ END; $$ LANGUAGE PLPGSQL STRICT STABLE; - -CREATE OR REPLACE FUNCTION collectionHQ.write_item_rows_to_stdout (TEXT, INT) RETURNS TEXT AS $$ +DROP FUNCTION IF EXISTS collectionHQ.write_item_rows_to_stdout (TEXT, INT); +CREATE OR REPLACE FUNCTION collectionHQ.write_item_rows_to_stdout (TEXT, INT) RETURNS VOID AS $$ -- Usage: SELECT collectionHQ.write_item_rows_to_stdout ('LIBRARYCODE',org_unit_id); DECLARE @@ -203,7 +203,8 @@ CREATE OR REPLACE FUNCTION collectionHQ.write_item_rows_to_stdout (TEXT, INT) RE $$ LANGUAGE plpgsql; -CREATE OR REPLACE FUNCTION collectionHQ.write_bib_rows_to_stdout (TEXT, INT) RETURNS TEXT AS $$ +DROP FUNCTION IF EXISTS collectionHQ.write_bib_rows_to_stdout(TEXT, INT); +CREATE OR REPLACE FUNCTION collectionHQ.write_bib_rows_to_stdout (TEXT, INT) RETURNS VOID AS $$ -- Usage: SELECT collectionHQ.write_bib_rows_to_stdout('LIBRARYCODE', org_unit_id); DECLARE -- 2.11.0