Bryan Encina wrote:
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Roy Souther
Sent: Monday, June 27, 2005 10:17 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] How can I simply substatue a value in a query?
I want to do a simple substatution of a value in a query. For example I have a
boolean field that wil return t or f for True and False. I would like it to
return Yes or No. I don't want to have a 2x2 table to look up the output. I
don't want to use stored procedue.
I think there is a better way, somthing very simple but I cannot remember what
it is.
-------------
I think a CASE statement is what you want. Check the Conditional Expressions
section of the docs at:
http://www.postgresql.org/docs/8.0/interactive/functions-conditional.html
HTH,
Bryan Encina
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
select case "field"
when 'T' then 'Yes'
when 'F' then 'No'
else null end
from ...
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
