Content-Type: text/plain;
  charset="iso-8859-1"
From: Josh Berkus <josh@agliodbs.com>
Organization: Aglio Database Solutions
To: Rod Taylor <pg@rbt.ca>, Greg Stark <gsstark@mit.edu>
Subject: Re: SQL challenge--top 10 for each key value?
Date: Fri, 9 Apr 2004 09:06:39 -0700
User-Agent: KMail/1.4.3
Cc: Jeff Boes <jboes@nexcerpt.com>, pgsql-sql@postgresql.org
References: <33af4fa4e4ec230574cefcff737ea40a@news.teranews.com>
	<87r7uyf3ki.fsf@stark.xeocode.com>
	<1081481466.56361.808.camel@jester>
In-Reply-To: <1081481466.56361.808.camel@jester>
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <200404090906.39541.josh@agliodbs.com>

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