Re: Re: Use of the LIMIT clause ?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Re: Use of the LIMIT clause ?
Дата
Msg-id 200103202119.QAA17359@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Re: Use of the LIMIT clause ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Is this a TODO item?  Seems we should match MySQL, seeing as we took the
> > feature syntax from them.
> 
> Question is, will more people be inconvenienced if we change it than if
> we leave it alone?  Seems like someone gets screwed either way ...

No question about it.  One solution would be to disable this syntax for
one release and then fix it in the one after that.  We already offer
LIMIT/OFFSET, which is what they should be using anyway.  If we can't
remember, and no one reported the bug for many releases, odds are no one
was using that more limited form anyway.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: Use of the LIMIT clause ?
Следующее
От: Jie Liang
Дата:
Сообщение: I cannot vacuum