On 8/22/2014 9:29 AM, hubert depesz lubaczewski wrote:
select * from table where pkey = <value> limit 1 for update;
why is there a limit 1 in there? pkey=somevalue should only return a single row. if it DID return multiple rows, you don't have an ORDER BY, so the limit 1 would be indeterminate.
-- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general