Re: top predicate

From: "Karen Hill" <karen_hill22(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: top predicate
Date: 2006-05-11 23:52:28
Message-ID: 1147391548.081261.315050@i40g2000cwc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Tom Lane wrote:
> "Karen Hill" <karen_hill22(at)yahoo(dot)com> writes:
> > It seems PostgreSQL doesn't have a TOP Predicate. Why is that?
>
> It's not in the SQL standard. If we were to implement something like
> what I think you're asking for (your example is way underspecified),
> it'd probably look like SQL2003's window functions.
>

Hi Tom,

The TOP predicate seemed to be really common in some other RDBMS. I
guess it isn't in the standard since oracle seems to be missing it in
9i. Maybe 10g has it.

http://www.oracle.com/technology/tech/migration/ama/exchange/docs/ss2k/SELECTStatement.htm

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2006-05-11 23:59:59 Re: [PERFORM] Arguments Pro/Contra Software Raid
Previous Message Bruce Momjian 2006-05-11 23:45:54 Re: [PERFORM] Arguments Pro/Contra Software Raid