Thread

1. case with distinct

   Merrill Oveson <merrill@actarg.com> — 2000-12-12T18:39:05Z

   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?
   
   
   

2. Re: case with distinct

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-12-12T19:09:18Z

   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