Re: CASE

From: "Victor Yegorov" <viy(at)pirmabanka(dot)lv>
To: "Rudi Starcevic" <rudi(at)oasis(dot)net(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: CASE
Date: 2003-04-08 11:09:58
Message-ID: 20030408110958.GX1712@pirmabanka.lv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

* 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

In response to

  • Re: CASE at 2003-04-08 10:57:59 from Rudi Starcevic

Responses

  • Re: CASE at 2003-04-08 11:20:44 from Rudi Starcevic

Browse pgsql-sql by date

  From Date Subject
Next Message Rudi Starcevic 2003-04-08 11:20:44 Re: CASE
Previous Message Rudi Starcevic 2003-04-08 10:57:59 Re: CASE