Re: [BUGS] case with distinct

[Tom Lane]

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
            from vend

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

                        regards, tom lane