This works:
select
orgid,
case when status = 'y' then '1' else '0' end
from vend
This doesn't:
select distinct
orgid,
case when status = 'y' then '1' else '0' end
from vend
The only difference is the absence of distinct clause.
bug?
- Re: [BUGS] case with distinct Merrill Oveson
- Re: [BUGS] case with distinct Tom Lane
