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