Postgres Pro
Downloads
Home   >   mailing lists

Thread: Select limit... erm so..

Select limit... erm so..

From
huongch@bigfoot.com (Flancer)
Date:
OK, saw in the latest history file in the CVS that limit #,# will be
totally gone in 7.3.
So does this mean 7.2 will support both limit #,# and limit # offset #
?

Thanks.

Re: Select limit... erm so..

From
Bruce Momjian
Date:
> OK, saw in the latest history file in the CVS that limit #,# will be
> totally gone in 7.3.
> So does this mean 7.2 will support both limit #,# and limit # offset #
> ?

Yes.  Please start migrating to LIMIT # OFFSET #.

--
  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, Pennsylvania 19026

Re: Select limit... erm so..

From
Tom Lane
Date:
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> OK, saw in the latest history file in the CVS that limit #,# will be
>> totally gone in 7.3.
>> So does this mean 7.2 will support both limit #,# and limit # offset #
>> ?

> Yes.  Please start migrating to LIMIT # OFFSET #.

Every version of Postgres that's had LIMIT at all has supported both
syntaxes.  LIMIT # OFFSET # is not a new feature.

            regards, tom lane