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.