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(at)oasis(dot)net(dot)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