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 349685284D for ; Mon, 27 Jun 2005 14:32:15 -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 58904-06 for ; Mon, 27 Jun 2005 17:31:39 +0000 (GMT) Received: from mx5.net.nih.gov (mx5.net.nih.gov [165.112.130.36]) by svr1.postgresql.org (Postfix) with ESMTP id 539FB52833 for ; Mon, 27 Jun 2005 14:31:38 -0300 (ADT) Received: from mx5.net.nih.gov (localhost [127.0.0.1]) by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j5RHVaZ3006157 for ; Mon, 27 Jun 2005 13:31:38 -0400 Received: from WATSON (vpn-165-112-10-134.net.nih.gov [165.112.10.134]) by mx5.net.nih.gov (8.12.10/8.11.6) with SMTP id j5RHVYlZ006135; Mon, 27 Jun 2005 13:31:35 -0400 Message-ID: <001401c57b3e$12b5f2b0$5179f345@WATSON> From: "Sean Davis" To: "Roy Souther" , References: <1119892618.7882.4.camel@UtopiaPlanetia> Subject: Re: How can I simply substatue a value in a query? Date: Mon, 27 Jun 2005 13:31:37 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0011_01C57B1C.8B580770" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.182 tagged_above=0 required=5 tests=AWL, HTML_60_70, HTML_MESSAGE, HTML_TAG_EXIST_TBODY X-Spam-Level: X-Archive-Number: 200506/315 X-Sequence-Number: 21916 This is a multi-part message in MIME format. ------=_NextPart_000_0011_01C57B1C.8B580770 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable ----- Original Message -----=20 From: Roy Souther=20 To: pgsql-sql@postgresql.org=20 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. =20 See CASE: http://www.postgresql.org/docs/8.0/interactive/functions-conditional.html= #AEN12006 Sean ------=_NextPart_000_0011_01C57B1C.8B580770 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable =EF=BB=BF
 
----- Original Message -----
From:=20 Roy = Souther=20
Sent: Monday, June 27, 2005 = 1:16 PM
Subject: [SQL] How can I simply = substatue=20 a value in a query?

I want to do a simple substatution of a value in a = query. For=20 example I have a boolean field that wil return t or f for True and = False. I=20 would like it to return Yes or No. I don't want to have a 2x2 table to = look up=20 the output. I don't want to use stored procedue.

I think there = is a=20 better way, somthing very simple but I cannot remember what it is.
 
 
See CASE:
http://www.postgresql.org/docs/8.0/interactive/functio= ns-conditional.html#AEN12006
 
Sean
 
------=_NextPart_000_0011_01C57B1C.8B580770--