On 2014-09-02 10:21:50 -0400, Tom Lane wrote: > 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.
Personally I think ONE ROW UPDATE ... reads nicely and SQL-ish. But it's not very expandable to other numbers. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
