Message-ID: <44884752.7030303@dafunks.com>
Date: Thu, 08 Jun 2006 10:50:42 -0500
From: George Handin <postgresql@dafunks.com>
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
To: Richard Broersma Jr <rabroersma@yahoo.com>
CC: pgsql-sql@postgresql.org
Subject: Re: Query to return modified results at runtime?
References: <20060608043236.96435.qmail@web31810.mail.mud.yahoo.com>
In-Reply-To: <20060608043236.96435.qmail@web31810.mail.mud.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Richard Broersma Jr wrote:
>> ID    Color
>> ---   -------
>> 1     Blue
>> 2     Red
>> 3     Green
>> 4     Orange
>>
>> How would I rewrite the query to return results where the colors are 
>> replaced by letters to give the following results?
>>
>> ID    Color
>> ---   -------
>> 1     A
>> 2     D
>> 3     B
>> 4     C
> 
> 
> http://www.postgresql.org/docs/8.1/interactive/functions-conditional.html
> 
> this is probably the easiest to implement but hard to mangage over time.  Another solution would
> be to create color_code table that is referenced by your test table.  Then when you can create a
> query as: select a.ID, b.code from test as a join color_code as b on a.color = b.color;
> 
> There are additional solutions to this also. But these two are probably the easiest.

Thanks!