Re: How can I simply substatue a value in a query? - Mailing list pgsql-sql

From Sean Davis
Subject Re: How can I simply substatue a value in a query?
Date
Msg-id 001401c57b3e$12b5f2b0$5179f345@WATSON
Whole thread Raw
In response to How can I simply substatue a value in a query?  (Roy Souther <roy@SiliconTao.com>)
List pgsql-sql

 
----- Original Message -----
Sent: Monday, June 27, 2005 1:16 PM
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.
 
 
See CASE:
 
Sean
 

pgsql-sql by date:

Previous
From: "jimmy.olsen"
Date:
Subject: pg_attribute.attlen -1 for varchar e pbchar fields
Next
From: "Jim Buttafuoco"
Date:
Subject: Re: How can I simply substatue a value in a query?