Re: PL/pgSQL 2

Marko Tiikkaja <marko@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