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

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Дата
Msg-id 1030534769.478.3.camel@lerlaptop.lerctr.org
обсуждение исходный текст
Ответ на Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Список pgsql-hackers
On Tue, 2002-08-27 at 23:29, Tom Lane wrote: 
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > OK, patch attached.  It was actually easier than I thought.  We have to
> > decide if we are going to remove the old syntax in 7.4.
> 
> I'd say "no".  There's no compelling reason to break backward
> compatibility here --- certainly a couple more productions in gram.y
> isn't enough reason.
I agree here.  Why intentionally break something that doesn't violate
standards, and would cause people to have to look at all their queries.
I personally hope y'all do *NOT* remove the old syntax. 
> 
> But I think it'd be sufficient to document only the new syntax.
Why? If both old and new are acceptable, why not document it? 
(Just curious, I'm not wedded to it). 


-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749



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

Предыдущее
От: Sir Mordred The Traitor
Дата:
Сообщение: @(#)Mordre Labs advisory 0x0005: Several buffer overruns in PostgreSQL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Open 7.3 items