Re: CASE - Mailing list pgsql-sql

From Tom Lane
Subject Re: CASE
Date
Msg-id 4379.1049863648@sss.pgh.pa.us
Whole thread Raw
In response to Re: CASE  (Rudi Starcevic <rudi@oasis.net.au>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Rudi Starcevic
Date:
Subject: Re: CASE
Next
From: Rudi Starcevic
Date:
Subject: Re: CASE