Re: LIMIT modifier - Mailing list pgsql-general

From Roderick A. Anderson
Subject Re: LIMIT modifier
Date
Msg-id Pine.LNX.4.33.0312151049090.27584-100000@main.cyber-office.net
Whole thread Raw
In response to Re: LIMIT modifier  (Arjen van der Meijden <acmmailing@vulcanus.its.tudelft.nl>)
List pgsql-general
On Mon, 15 Dec 2003, Arjen van der Meijden wrote:

> "Nonstandard Clauses
>
> The clauses DISTINCT ON, LIMIT, and OFFSET are not defined in the SQL
> standard."

Humm.  Is there a SQL standard to return a subset of the selected tuples?
This being contrary to relational theory I believe.  :-)

> TOP x isn't in the standard as well, afaik.

I had no doubts there.


Thanks,
Rod
--
    "Open Source Software - You usually get more than you pay for..."
     "Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"



pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: PostgreSQL on Windows Server 2003
Next
From: Troels Arvin
Date:
Subject: Re: LIMIT modifier