Re: [BUGS] case with distinct

Merrill Oveson <[EMAIL PROTECTED]> writes: > This doesn't: > select distinct > orgid, > case when status = 'y' then '1' else '0' end > from vend Try select distinct orgid, case when status = 'y' then '1'::text else '0'::text end

[BUGS] case with distinct

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 dis