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?
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных