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