Thread: 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 distinct clause.
bug?

Merrill Oveson <merrill@actarg.com> 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
            from vend

7.1 is less picky about unknown-type constants...

            regards, tom lane