Re: Need help with embedded CASEs

Denis Bucher writes:

> SELECT CASE WHEN '2001-11-07' = current_date THEN 't' ELSE 'f' END AS
> flag_today, CASE WHEN flag_today THEN current_time ELSE '00:00' END AS
> time_iftoday;
>
> Why doesn't it work ?

For one thing, flag_today is not a made boolean expression, so the second
CASE wouldn't even work on that account.  Secondly, the "AS" aliases in
the select list aren't available as variables in the other items in the
select list.

A corrected version would be:

SELECT   CASE WHEN DATE '2001-11-07' = current_date THEN true ELSE false END       AS flag_today,   CASE WHEN DATE
'2001-11-07'= current_date THEN current_time ELSE TIME '00:00' END       AS time_iftoday;
 

Or shorter:

SELECT   DATE '2001-11-07' = current_date AS flag_today,   CASE WHEN DATE '2001-11-07' = current_date THEN current_time
ELSETIME '00:00' END       AS time_iftoday;
 

-- 
Peter Eisentraut   peter_e@gmx.net