select case field
when 'Stuff' then 'Junk'
when 'Crap' then 'Darn'
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.
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
pgsql-novice by date
|Next:||From: Chad Thompson||Date: 2002-10-25 19:21:11|
|Subject: Re: Select case|
|Previous:||From: Chad Thompson||Date: 2002-10-25 18:59:27|
|Subject: Select case|