On Fri, Aug 22, 2014 at 7:29 PM, John R Pierce <pie...@hogranch.com> wrote:
> 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. > leftover from some other thing. depesz
