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 #
?
Thanks.
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
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