Re: CASE - Mailing list pgsql-sql

From Rudi Starcevic
Subject Re: CASE
Date
Msg-id 20030408105759.M33127@oasis.net.au
Whole thread Raw
In response to Re: CASE  ("Victor Yegorov" <viy@pirmabanka.lv>)
Responses Re: CASE  ("Victor Yegorov" <viy@pirmabanka.lv>)
List pgsql-sql
Victor,

Thanks for your time ..

When casting inside a COALESCE function should it be something like:

WHEN COALESCE( MAX(e.edate),'2003-01-01'::date ) >= now()::date THEN 'events'

instead of:

WHEN COALESCE( MAX(e.edate),'2003-01-01') >= now()::date THEN 'events'

Regards
Rudi



pgsql-sql by date:

Previous
From: "2000info"
Date:
Subject: unsubscribe
Next
From: "Victor Yegorov"
Date:
Subject: Re: CASE