2012/12/21 Tom Lane <t...@sss.pgh.pa.us>: > Christopher Browne <cbbro...@gmail.com> writes: >> This is adding specific syntax for what seems like an unusual case to me, >> which seems like an unworthwhile complication. > > That was my first reaction too, but Marko's followon examples seem to > make a reasonable case for it. There are many situations where you > expect an UPDATE or DELETE to hit exactly one row. Often, programmers > won't bother to add code to check that it did ... but if a one-word > addition to the command can provide such a check, it seems more likely > that they would add the check.
and it can be used for optimization - it can be optimized for fast first row Regards Pavel > > 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers