Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Дата
Msg-id GNELIHDDFBOCMGBFGEFOMEOMCDAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-sql
> 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Calculation Error on Epoch?