Select limit... erm so..

Started by Huong Chia Hiangover 24 years ago3 messagesgeneral
Jump to latest
#1Huong Chia Hiang
huongch@bigfoot.com

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.

#2Bruce Momjian
bruce@momjian.us
In reply to: Huong Chia Hiang (#1)
Re: Select limit... erm so..

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
#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: Bruce Momjian (#2)
Re: Select limit... erm so..

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