Re: Simulating LIMIT/OFFSET in a subquery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jamie Walker" <jamie(at)sagaxis(dot)co(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Simulating LIMIT/OFFSET in a subquery
Date: 2001-02-12 04:10:47
Message-ID: 14358.981951047@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Jamie Walker" <jamie(at)sagaxis(dot)co(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message guard 2001-02-12 05:25:08 how to select * from database1 table,database2 table
Previous Message Dave Wedwick 2001-02-12 03:19:11 Trigger question