Re: CASE

Victor,

Thanks again,

I'll try first thing in the morning as I'm at home now.
Now I can sleep well knowing a solution is at hand :-)

I'm very pleased as that was a small part of what I think is
an advanced query and look forward to seeing it work.

I'll send a reply first thing tomorrow when I get to work.
Cheers
Rudi.

> * Rudi Starcevic <rudi@oasis.net.au> [08.04.2003 14:06]:
> > When casting inside a COALESCE function should it be something like:
> > 
> > WHEN COALESCE( MAX(e.edate),'2003-01-01'::date ) >= now()::date THEN 'events'
> 
> Yes.
> Please, try it and report if it works.
> 
> -- 
> 
> Victor Yegorov