Re: SQL challenge--top 10 for each key value?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, Jeff Boes <jboes(at)nexcerpt(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL challenge--top 10 for each key value?
Date: 2004-04-09 06:11:44
Message-ID: 21760.1081491104@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Rod Taylor <pg(at)rbt(dot)ca> writes:
> ROW_NUMBER() is a spec defined function. (6.10 of SQL200N)

If the spec doesn't even have a year number yet, you can hardly expect
real implementations to support it ;-). There is no such thing in the
extant specs SQL92 or SQL99.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message SZŰCS Gábor 2004-04-09 12:23:07 Re: could not devise a query plan
Previous Message Rod Taylor 2004-04-09 03:31:07 Re: SQL challenge--top 10 for each key value?