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
>
>
>