Re: LIMIT modifier

From: "Roderick A(dot) Anderson" <raanders(at)acm(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: LIMIT modifier
Date: 2003-12-15 18:51:56
Message-ID: Pine.LNX.4.33.0312151049090.27584-100000@main.cyber-office.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Troels Arvin 2003-12-15 19:12:32 Re: LIMIT modifier
Previous Message Troels Arvin 2003-12-15 18:51:45 Re: LIMIT modifier