| From: | Rudi Starcevic <rudi(at)oasis(dot)net(dot)au> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: CASE |
| Date: | 2003-04-09 04:59:34 |
| Message-ID: | 3E93A8B6.1000407@oasis.net.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)oasis(dot)net(dot)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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Denis @ Next2Me | 2003-04-09 05:54:46 | Re: [GENERAL] Yet Another (Simple) Case of Index not used |
| Previous Message | Tom Lane | 2003-04-09 04:47:28 | Re: CASE |