case with distinct

From: Merrill Oveson <merrill(at)actarg(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Cc: kyle(at)actarg(dot)com
Subject: case with distinct
Date: 2000-12-12 18:39:05
Message-ID: 3A3670C9.6E6C0E9F@actarg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2000-12-12 19:04:32 Re: constrains of array
Previous Message pgsql-bugs 2000-12-12 18:37:25 Solaris ODBC - linker flag needs to be set when building shared objects