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 (Bruce Momjian)
Список
Дерево обсуждения
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
Дата: