| 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: | Whole Thread | Raw Message | 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 |