Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL challenge--top 10 for each key value? - Mailing list pgsql-sql

From Tom Lane
Subject Re: SQL challenge--top 10 for each key value?
Date
Msg-id 21760.1081491104@sss.pgh.pa.us
Whole thread Raw
In response to Re: SQL challenge--top 10 for each key value?  (Rod Taylor <pg@rbt.ca>)
List pgsql-sql
Tree view 
Rod Taylor <pg@rbt.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

pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: SQL challenge--top 10 for each key value?
Next
From: "SZŰCS Gábor"
Date:
Subject: Re: could not devise a query plan