Skip site navigation (1) Skip section navigation (2)

Re: Select case

From: Doug Gorley <douggorley(at)shaw(dot)ca>
To: Chad Thompson <chad(at)weblinkservices(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Select case
Date: 2002-10-25 19:04:47
Message-ID: 1035572687.16370.13.camel@h24-69-83-179 (view raw or flat)
Thread:
Lists: pgsql-novice
select case field
       when 'Stuff' then 'Junk'
       when 'Crap'  then 'Darn'
       end
from table

That'd ought to do what you want.

On Fri, 2002-10-25 at 11:59, Chad Thompson wrote:
> I want to be able to change the results that are output from a query like so.
> 
> select field
> from table
> if field = 'Stuff' then 'Junk'
> elseif field  = 'Crap' then 'Darn'
> 
> Since I am not quite sure what to look for, I have been unable to find anything in the docs.  Select case doesnt seem to do what I want, but maybe I just dont understand.
> 
> Thanks
> Chad
-- 
Doug Gorley | douggorley(at)shaw(dot)ca     OpenPGP Key ID: 0xA221559B
Fingerprint: D707 DB92 E64B 69DA B8C7  2F65 C5A9 5415 A221 559B
Interested in public-key cryptography?    http://www.gnupg.org/

In response to

  • Select case at 2002-10-25 18:59:27 from Chad Thompson

Responses

pgsql-novice by date

Next:From: Chad ThompsonDate: 2002-10-25 19:21:11
Subject: Re: Select case
Previous:From: Chad ThompsonDate: 2002-10-25 18:59:27
Subject: Select case

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group