From: Josh Berkus <josh@agliodbs.com>
To: Rod Taylor <pg@rbt.ca>
To: Greg Stark <gsstark@mit.edu>
Cc: Jeff Boes <jboes@nexcerpt.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL challenge--top 10 for each key value?
Date: Fri, 9 Apr 2004 09:06:39 -0700
Message-ID: <200404090906.39541.josh@agliodbs.com> (raw)
In-Reply-To: <1081481466.56361.808.camel@jester>
References: <33af4fa4e4ec230574cefcff737ea40a@news.teranews.com>
<87r7uyf3ki.fsf@stark.xeocode.com>
<1081481466.56361.808.camel@jester>
Rod,
> Something along the lines of the below would accomplish what you want
> according to spec. ROW_NUMBER() is a spec defined function. (6.10 of
> SQL200N)
Great leaping little gods! They added something called "row number" to the
spec?
Boy howdy, folks were right ... the ANSI committee really has completly blown
off the relational model completely. First there was the addition of
network-database functions so that IBM could make DB2 look more like a real
database, now this ....
When a standards committee becomes hostage to a handful of vendors, kiss real
standards goodbye.
--
Josh Berkus
Aglio Database Solutions
San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, pg@rbt.ca, gsstark@mit.edu, jboes@nexcerpt.com
Subject: Re: SQL challenge--top 10 for each key value?
In-Reply-To: <200404090906.39541.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox