case with distinct
Merrill Oveson <merrill@actarg.com>
From: Merrill Oveson <merrill@actarg.com>
To: "pgsql-bugs@postgresql.org" <pgsql-bugs@postgresql.org>
Cc: kyle@actarg.com
Date: 2000-12-12T18:39:05Z
Lists: pgsql-bugs
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?