Marko Tiikkaja <marko(at)joh(dot)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