Marko Tiikkaja <ma...@joh.to> 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 (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
