Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Дата
Msg-id 1030587488.1693.11.camel@jester
обсуждение исходный текст
Ответ на Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Список pgsql-hackers
> Yes, I thought about that.  People want to show both SELECT syntaxes,
> but how would you do that --- show the SELECT syntax twice with just
> those last two clauses reversed --- yuck.

select .... [ <stmt group>, ... ]

<stmt group> :  [ FOR UPDATE | LIMIT ]


The above, or something along those lines, would show order
independence.


> We could easily mention that we allow both clause orderings in the text
> somewhere.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Larry Rosenman
Дата:
Сообщение: Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Serious problem with my postgres