Re: CASE - Mailing list pgsql-sql

From Victor Yegorov
Subject Re: CASE
Date
Msg-id 20030408110958.GX1712@pirmabanka.lv
Whole thread Raw
In response to Re: CASE  ("Rudi Starcevic" <rudi@oasis.net.au>)
Responses Re: CASE
List pgsql-sql
* 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

pgsql-sql by date:

Previous
From: "Rudi Starcevic"
Date:
Subject: Re: CASE
Next
From: "Rudi Starcevic"
Date:
Subject: Re: CASE