Marko Tiikkaja <> writes:
> For example:

> UPDATE foo WHERE bar = 1;  -- must affect exactly one row
> PERFORM UPDATE foo WHERE bar = 1; -- can affect any number of rows

FWIW, I agree with the position that this would be a completely wrong
thing to do.  UPDATE should work like it does in plain SQL.  If you want
a restriction to "exactly one row", that needs to be a modifier.

I take no position on how the modifier should be spelled, though.

                        regards, tom lane

Sent via pgsql-hackers mailing list (
To make changes to your subscription:

Reply via email to