Re: How to tell if that UPDATE worked?

>     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 <int4_variable>;

Thanks for the tip.  That is exactly what I needed.  plpgsql is a
painful language in many ways, but it is also very straightforward, so
I'm writing the bulk of my project in it.

>     Er - is this another added feature where we're still  lacking
>     documentation?

As pointed out by Tom in a subsequent email, there is one cryptic line
in there, which is probably why I overlooked it...

Thanks for your help