Re: CASE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rudi Starcevic <rudi(at)oasis(dot)net(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: CASE
Date: 2003-04-09 04:47:28
Message-ID: 4379.1049863648@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

  • Re: CASE at 2003-04-08 23:13:30 from Rudi Starcevic

Responses

  • Re: CASE at 2003-04-09 04:59:34 from Rudi Starcevic

Browse pgsql-sql by date

  From Date Subject
Next Message Rudi Starcevic 2003-04-09 04:59:34 Re: CASE
Previous Message Martijn van Oosterhout 2003-04-09 03:18:39 Re: [GENERAL] Yet Another (Simple) Case of Index not used