Postgres Pro
Downloads
Home   >   mailing lists

Re: Select limit... erm so.. - Mailing list pgsql-general

From Tom Lane
Subject Re: Select limit... erm so..
Date
Msg-id 14283.1004388855@sss.pgh.pa.us
Whole thread Raw
In response to Re: Select limit... erm so..  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Mihai Gheorghiu"
Date:
Subject: Table restructuring with referential integrity
Next
From: Stephan Szabo
Date:
Subject: Re: Table restructuring with referential integrity