Postgres Pro
Downloads
Home   >   mailing lists

Re: Simulating LIMIT/OFFSET in a subquery - Mailing list pgsql-sql

From Tom Lane
Subject Re: Simulating LIMIT/OFFSET in a subquery
Date
Msg-id 14358.981951047@sss.pgh.pa.us
Whole thread Raw
In response to Simulating LIMIT/OFFSET in a subquery  ("Jamie Walker" <jamie@sagaxis.co.uk>)
List pgsql-sql
Tree view 
"Jamie Walker" <jamie@sagaxis.co.uk> writes:
> But of course, ORDER BY and LIMIT are not allowed in sub-queries.

FWIW, they are allowed as of 7.1 ...
        regards, tom lane

pgsql-sql by date:

Previous
From: Roberto Mello
Date:
Subject: Contributing Documentation to PG
Next
From: "Dominic J. Eidson"
Date:
Subject: Re: [GENERAL] Re: Re: SQL Join - MySQL/PostgreSQL difference?