[EMAIL PROTECTED] wrote:
I'm writing some stuff in PL/pgsql (actually, a lot of stuff). I have
a question: At various times, it does UPDATEs. Is there a way to tell
if the UPDATE actually affected any rows or not? I couldn't see how
to get UPDATE to return anything.
Do a
GET
Do a
GET DIAGNOSTICS SELECT PROCESSED INTO int4_variable;
directly after an INSERT, UPDATE or DELETE statement and
you'll know how many rows have been hit.
Also you can get the OID of an inserted row with
GET DIAGNOSTICS SELECT RESULT INTO
Jan Wieck [EMAIL PROTECTED] writes:
Do a
GET DIAGNOSTICS SELECT PROCESSED INTO int4_variable;
directly after an INSERT, UPDATE or DELETE statement and
you'll know how many rows have been hit.
Also you can get the OID of an inserted row with
GET