Re: To Postgres Devs : Wouldn't changing the select limit - Mailing list pgsql-general

Bruce Momjian <pgman@candle.pha.pa.us> 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