X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7CDCF4758E6
	for <pgsql-sql@postgresql.org>; Wed,  9 Apr 2003 00:55:28 -0400 (EDT)
Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2])
	by postgresql.org (Postfix) with ESMTP id 29FC8474E42
	for <pgsql-sql@postgresql.org>; Wed,  9 Apr 2003 00:55:27 -0400 (EDT)
Received: from oasis.net.au (guardian [210.8.139.5])
	by water.oasis.net.au (8.9.3/8.9.3/Debian 8.9.3-21) with ESMTP id
	OAA02226
	for <pgsql-sql@postgresql.org>; Wed, 9 Apr 2003 14:58:49 +1000
X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5]
	claimed to be oasis.net.au
Message-ID: <3E93A8B6.1000407@oasis.net.au>
Date: Wed, 09 Apr 2003 14:59:34 +1000
From: Rudi Starcevic <rudi@oasis.net.au>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.1) Gecko/20020826
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: CASE
References: <3E928853.7090801@oasis.net.au>
	<20030408094039.GS1712@pirmabanka.lv>
	<877ka519e0.fsf@stark.dyndns.tv> <26705.1049812237@sss.pgh.pa.us>
	<3E93579A.3030006@oasis.net.au> <4379.1049863648@sss.pgh.pa.us>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Status: No, hits=-27.3 required=5.0
	tests=BAYES_01,EMAIL_ATTRIBUTION,REFERENCES,
	USER_AGENT_MOZILLA_UA,X_AUTH_WARNING autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/126
X-Sequence-Number: 12827

Tom,

I see ..
Thanks.

I'll need to rewrite my query.
I'm not sure I understand right now so it will be a good challenge for me ..

Any tips appreciated :-)

Cheers
Rudi.

Tom Lane wrote:

>Rudi Starcevic <rudi@oasis.net.au> writes:
>  
>
>>However there is one event which is in the past '2003-04-01' which is 
>>still coming up as 'events' instead of 'noevents'.
>>    
>>
>
>But you're grouping over members and venues, and taking the max across
>event dates in each group.  A past event for a venue won't affect
>anything, if there are later events for that venue.
>
>			regards, tom lane
>
>  
>