Re: To Postgres Devs : Wouldn't changing the select limit

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: To Postgres Devs : Wouldn't changing the select limit
Дата
Msg-id
11415.1003549484@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Re: To Postgres Devs : Wouldn't changing the select limit huongch@bigfoot.com (Flancer)
Bruce Momjian  writes:
> One more thing.  I have added the code to suggest alternate syntax for
> LIMIT #,#:

>     test=> select * from pg_class LIMIT 1,1;
>     ERROR:  LIMIT #,# syntax no longer supported.  Use LIMIT # OFFSET #.

If you're going to do that, *please* suggest the *correct* substitution.
AFAICT, our version of LIMIT m,n transposes to OFFSET m LIMIT n; but
your message suggests the opposite.

			regards, tom lane
В списке pgsql-general по дате отправления
От: Bruce Momjian
Дата:
От: Tom Lane
Дата:
FAQ