Postgres Pro
Downloads
Home   >   mailing lists

Select case - Mailing list pgsql-novice

From Chad Thompson
Subject Select case
Date
Msg-id 0fdf01c27c58$a4d2a630$32021aac@chad
Whole thread Raw
Responses Re: Select case  (Doug Gorley <douggorley@shaw.ca>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Parameters for views based on other views
Next
From: Doug Gorley
Date:
Subject: Re: Select case