|
|
 | | From: | Keith Worthington | | Subject: | Re: Returning a bool on DELETE in a proc. | | Date: | Tue, 18 Jan 2005 13:46:23 -0500 |
|
|
 | > Hi,
>
> I'm currently writing a function which encapsulates a delete and should
> return a bool as indicator for success.
>
> I tried:
>
> DELETE FROM "TariffDetails" WHERE "TariffId"=$1 and "BNumberPrefix"=$2;
> SELECT TRUE;
>
> but this makes me not happy.
> How can I distingruish wehter DELETE affected 0 or more rows and
> return that while DELETE is not capable of returning any value?
>
> And is the whole function executed if the DELETE fails or will it
> stop bevore the select?
>
> I had a read throu SQL-functions while nothing matched me.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
Robert,
I do not know what version you are working with but here is the 7.4
documentation on result status.
http://www.postgresql.org/docs/7.4/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
Kind Regards,
Keith
PS I am a novice myself so don't put too much faith in my post. ;-)
______________________________________________
99main Internet Services http://www.99main.com
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
|
|
|
