X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id D710552863
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 27 Jun 2005 14:17:03 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 55480-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 27 Jun 2005 17:17:00 +0000 (GMT)
Received: from priv-edtnes57.telusplanet.net (outbound01.telus.net
	[199.185.220.220])
	by svr1.postgresql.org (Postfix) with ESMTP id 1B9D952835
	for <pgsql-sql@postgresql.org>; Mon, 27 Jun 2005 14:16:58 -0300 (ADT)
Received: from UtopiaPlanetia ([142.179.175.123])
	by priv-edtnes57.telusplanet.net
	(InterMail vM.6.01.04.04 201-2131-118-104-20050224) with ESMTP id
	<20050627171659.NSMQ17932.priv-edtnes57.telusplanet.net@UtopiaPlanetia>
	for <pgsql-sql@postgresql.org>; Mon, 27 Jun 2005 11:16:59 -0600
Subject: How can I simply substatue a value in a query?
From: Roy Souther <roy@SiliconTao.com>
Reply-To: Roy Souther <roy@SiliconTao.com>
To: pgsql-sql@postgresql.org
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-okNovf7BY9qZNhQuSmrc"
Organization: Silicon Tao Technology Systems Inc.
Date: Mon, 27 Jun 2005 11:16:58 -0600
Message-Id: <1119892618.7882.4.camel@UtopiaPlanetia>
Mime-Version: 1.0
X-Mailer: Evolution 2.0.1-1mdk 
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.098 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO, HTML_50_60, HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200506/313
X-Sequence-Number: 21914


--=-okNovf7BY9qZNhQuSmrc
Content-Type: multipart/alternative; boundary="=-a1CATaEQZAaABRgTDvZe"


--=-a1CATaEQZAaABRgTDvZe
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

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.

Roy Souther
www.SiliconTao.com
Let Open Source help your business move beyond.

For security this message is digitally authenticated by GnuPG.




--=-a1CATaEQZAaABRgTDvZe
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; CHARSET=3DUTF-8">
  <META NAME=3D"GENERATOR" CONTENT=3D"GtkHTML/3.2.2">
</HEAD>
<BODY>
I want to do a simple substatution of a value in a query. For example I hav=
e a boolean field that wil return t or f for True and False. I would like i=
t to return Yes or No. I don't want to have a 2x2 table to look up the outp=
ut. I don't want to use stored procedue.<BR>
<BR>
I think there is a better way, somthing very simple but I cannot remember w=
hat it is.<BR>
<TABLE CELLSPACING=3D"0" CELLPADDING=3D"0" WIDTH=3D"100%">
<TR>
<TD>
<BR>
<TABLE CELLSPACING=3D"0" CELLPADDING=3D"0" WIDTH=3D"100%">
<TR>
<TD>
<U><A HREF=3D"mailto:roy@SiliconTao.com">Roy Souther</A></U><BR>
<U><A HREF=3D"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=3D"http:=
//www.gnupg.org">GnuPG</A></U>.
</TD>
</TR>
</TABLE>
<BR>
<BR>
<BR>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>

--=-a1CATaEQZAaABRgTDvZe--

--=-okNovf7BY9qZNhQuSmrc
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQBCwDSIY62fql08qicRAolbAKCOkGYILN2Bkay77yBglkfbeOvTKwCePEDl
p2PIvuvGydOX7O6Y5bQlxQU=
=ymW1
-----END PGP SIGNATURE-----

--=-okNovf7BY9qZNhQuSmrc--