From b923194dcebed74c6d815a24a5e2d4b1dacb1bf2 Mon Sep 17 00:00:00 2001 From: erickson Date: Wed, 14 Jan 2009 22:02:56 +0000 Subject: [PATCH] return the new ID on success git-svn-id: svn://svn.open-ils.org/ILS/trunk@11830 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/999.functions.global.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/999.functions.global.sql b/Open-ILS/src/sql/Pg/999.functions.global.sql index 8f6c6e62fc..3dbe1cf235 100644 --- a/Open-ILS/src/sql/Pg/999.functions.global.sql +++ b/Open-ILS/src/sql/Pg/999.functions.global.sql @@ -167,18 +167,19 @@ $$; -CREATE OR REPLACE FUNCTION actor.approve_pending_address(pending_id INT) RETURNS VOID AS $$ +CREATE OR REPLACE FUNCTION actor.approve_pending_address(pending_id INT) RETURNS BIGINT AS $$ DECLARE old_id INT; BEGIN SELECT INTO old_id replaces FROM actor.usr_address where id = pending_id; IF old_id IS NULL THEN RAISE NOTICE 'Address % does not replace any address', pending_id; - RETURN; + RETURN NULL; END IF; DELETE FROM actor.usr_address WHERE id = -old_id; UPDATE actor.usr_address SET id = -id WHERE id = old_id; UPDATE actor.usr_address SET replaces = NULL, id = old_id WHERE id = pending_id; + RETURN old_id; END $$ LANGUAGE plpgsql; -- 2.11.0