Postgres Pro
Downloads
Home   >   mailing lists

Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Date
Msg-id GNELIHDDFBOCMGBFGEFOMEOMCDAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Tree view 
> OK, no one has commented on this, so I guess I am going to have to guess
> the group's preference.
>
> My guess, seeing as very few probably use LIMIT and FOR UPDATE together,
> is to swap them and document it in the release notes.  Was I correct in
> my guess?

I'm sure very few people do it - but are you sure you can't just allow both
syntaxes?

Chris

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Next
From: "Josh Berkus"
Date:
Subject: Calculation Error on Epoch?