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
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 |