Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 0117E9FA3DB
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 27 Aug 2007 15:20:36 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 86190-04-6 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 27 Aug 2007 15:20:28 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from mtao02.charter.net (mtao02.charter.net [209.225.8.187])
	by postgresql.org (Postfix) with ESMTP id EA6649FA518
	for <pgsql-sql@postgresql.org>; Mon, 27 Aug 2007 15:20:30 -0300 (ADT)
Received: from aa04.charter.net ([10.20.200.156]) by mtao02.charter.net
	(InterMail vM.7.08.02.00 201-2186-121-20061213) with ESMTP
	id <20070827182021.RAOT11829.mtao02.charter.net@aa04.charter.net>;
	Mon, 27 Aug 2007 14:20:21 -0400
Received: from [10.0.1.2] (really [66.188.165.91]) by aa04.charter.net
	with ESMTP id <20070827182021.SYOB1254.aa04.charter.net@[10.0.1.2]>;
	Mon, 27 Aug 2007 14:20:21 -0400
In-Reply-To: <60F656A0-805D-4C3B-BCA5-742AC6C866E0@seespotcode.net>
References: <46D2FD9F.3020000@gmx.net>
	<20070827125102.e52b43de.darcy@druid.net>
	<4CB5D209-C0CC-466E-A967-E766D6AD799B@joelrichard.com>
	<60F656A0-805D-4C3B-BCA5-742AC6C866E0@seespotcode.net>
Mime-Version: 1.0 (Apple Message framework v752.2)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <56BD71D2-D761-4A80-9B3B-40CD7BF4BE8A@seespotcode.net>
Cc: Joel Richard <postgres@joelrichard.com>,
	"D'Arcy J.M. Cain" <darcy@druid.net>, Claudia Kosny <ckosny@gmx.net>,
	sql pgsql <pgsql-sql@postgresql.org>
Content-Transfer-Encoding: 7bit
From: Michael Glaesemann <grzm@seespotcode.net>
Subject: Re: fetch first rows of grouped data
Date: Mon, 27 Aug 2007 13:20:18 -0500
To: Michael Glaesemann <grzm@seespotcode.net>
X-Mailer: Apple Mail (2.752.2)
X-Chzlrs: 0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200708/226
X-Sequence-Number: 29164


On Aug 27, 2007, at 13:12 , Michael Glaesemann wrote:

> select city, event, event_date, (
>     select count(event)
>     from events i
>     where i.city = o.city
>         and i.event_date < o.event_date
>         and event_date > current_date -- make sure they're future  
> events

This should be i.event_date > current_date to be explicit.

>         ) as nearness_rank
> from events o
> where event_date > current_date -- make sure they're future events
> having nearness_rank <= 1;

Michael Glaesemann
grzm seespotcode net