Postgres Pro
Downloads
Home   >   mailing lists

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

From Roy Souther
Subject How can I simply substatue a value in a query?
Date
Msg-id 1119892618.7882.4.camel@UtopiaPlanetia
Whole thread Raw
Responses Re: How can I simply substatue a value in a query?
Re: How can I simply substatue a value in a query?
List pgsql-sql
Tree view 
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
forTrue 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
wantto use stored procedue.<br /><br /> I think there is a better way, somthing very simple but I cannot remember what
itis.<br /><table cellpadding="0" cellspacing="0" width="100%"><tr><td><br /><table cellpadding="0" cellspacing="0"
width="100%"><tr><td><u><ahref="mailto:roy@SiliconTao.com">Roy Souther</a></u><br /><u><a
href="http://www.SiliconTao.com">www.SiliconTao.com</a></u><br/> Let Open Source help your business move beyond.<br
/><br/> For security this message is digitally authenticated by <u><a href="http://www.gnupg.org">GnuPG</a></u>.
</td></tr></table><br/><br /><br /></td></tr></table>

pgsql-sql by date:

Previous
From: Markus Bertheau ☭
Date:
Subject: SELECT * FROM foo OFFSET -1 LIMIT 1
Next
From: "jimmy.olsen"
Date:
Subject: pg_attribute.attlen -1 for varchar e pbchar fields