Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 00F9B9FBD15 for ; Thu, 15 Feb 2007 17:47:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 85433-02 for ; Thu, 15 Feb 2007 17:47:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from weatherbeeta.com.au (218-214-212-153.people.net.au [218.214.212.153]) by postgresql.org (Postfix) with SMTP id D014A9FBC66 for ; Thu, 15 Feb 2007 17:47:23 -0400 (AST) Received: (qmail 5888 invoked from network); 15 Feb 2007 21:47:22 -0000 X-NetworkBox-HamSign: 0101;OUT;wbeetaau1;7326ee0456fb513cca0f0f0e6008f97e; Received: from mail.weatherbeeta.com.au (10.10.0.2) by network-box.weatherbeeta.com.au with SMTP; 15 Feb 2007 21:47:21 -0000 Received: (qmail 18356 invoked by uid 1166); 16 Feb 2007 08:47:21 +1100 Received: from 172.20.0.155 by mail.weatherbeeta.com.au (envelope-from , uid 1165) with qmail-scanner-1.25-st-qms (clamdscan: 0.88.6/2315. perlscan: 1.25-st-qms. Clear:RC:1(172.20.0.155):. Processed in 0.399627 secs); 15 Feb 2007 21:47:21 -0000 X-Antivirus-mail.weatherbeeta.com.au-Mail-From: phillip.smith@weatherbeeta.com.au via mail.weatherbeeta.com.au X-Antivirus-mail.weatherbeeta.com.au: 1.25-st-qms (Clear:RC:1(172.20.0.155):. Processed in 0.399627 secs Process 18347) Received: from it-phil.weatherbeeta.com.au (HELO wbaus090) (172.20.0.155) by mail.weatherbeeta.com.au with SMTP; 16 Feb 2007 08:47:20 +1100 From: "Phillip Smith" To: "'Ezequias Rodrigues da Rocha'" , Subject: Re: Retrieving 'Credit' when 'C' Date: Fri, 16 Feb 2007 08:47:14 +1100 Organization: Weatherbeeta Pty Ptd Message-ID: <004001c7514a$daf02730$9b0014ac@wbaus090> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0041_01C751A7.0E609F30" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 In-Reply-To: <55c095e90702150844h3159bfbbx83c71b6910f4a88f@mail.gmail.com> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Scanned-By-wbeetaau1: Virus scan performed by network-box X-Scanned-By-wbeetaau1: Scanner file id is wbeetaau1-1171576041.940-5879-000 X-Scanned-By-wbeetaau1: No known viruses found in message (received+scanned in 0.04/0.20 secs) X-Scanned-By-wbeetaau1: Spam-Check-Result: No, hits=0 required=7 tests= autolearn=no version=2.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/171 X-Sequence-Number: 27505 This is a multi-part message in MIME format. ------=_NextPart_000_0041_01C751A7.0E609F30 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable SELECT when, CASE WHEN type =3D 'C' THEN 'Credit' END AS type FROM mytable; =20 Assuming your column names are actually "when" and "type" you should = just have to change "mytable" to the correct table name and run in psql or = the SQL Window of pgAdmin or wherever you usually run your SQL queries to = get what you want. =20 =20 -----Original Message----- From: pgsql-sql-owner@postgresql.org = [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Ezequias Rodrigues da Rocha Sent: Friday, 16 February 2007 03:45 To: Ezequias Rodrigues da Rocha; pgsql-sql@postgresql.org Subject: Re: [SQL] Retrieving 'Credit' when 'C' =20 Just a question, where to put it ? I didn't notice yet.=20 =0A*******************Confidentiality and Privilege Notice*******************= =0A=0AThe material contained in this message is privileged and confidential to= =0Athe addressee. If you are not the addressee indicated in this message or= =0Aresponsible for delivery of the message to such person, you may not copy=0Aor= deliver this message to anyone, and you should destroy it and kindly=0Anotify= the sender by reply email.=0A=0AInformation in this message that does not relat= e to the official business=0Aof Weatherbeeta must be treated as neither given = nor endorsed by Weatherbeeta.=0AWeatherbeeta, its employees, contractors or as= sociates shall not be liable=0Afor direct, indirect or consequential loss aris= ing from transmission of this=0Amessage or any attachments=0A ------=_NextPart_000_0041_01C751A7.0E609F30 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

SELECT =      when,

CASE WHEN type =3D 'C' THEN 'Credit' END AS = type

FROM        = mytable;

 

Assuming your column names are = actually “when” and “type” you should just have to change = “mytable” to the correct table name and run in psql or the SQL Window of pgAdmin or = wherever you usually run your SQL queries to get what you want.

 

 

-----Original Message-----
From: = pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Ezequias Rodrigues da Rocha
Sent: Friday, 16 February 2007 03:45
To: Ezequias Rodrigues da = Rocha; pgsql-sql@postgresql.org
Subject: Re: [SQL] = Retrieving 'Credit' when 'C'

 

Just a = question, where to put it ? I didn't notice yet.


=

=0A*******************Confidentiality and Privilege Notice*************= ******=0A

=0AThe material contained in this message is privileged and conf= idential to=0Athe addressee. If you are not the addressee indicated in this m= essage or=0Aresponsible for delivery of the message to such person, you may no= t copy=0Aor deliver this message to anyone, and you should destroy it and kind= ly=0Anotify the sender by reply email.=0A

=0AInformation in this message that do= es not relate to the official business=0Aof Weatherbeeta must be treated as ne= ither given nor endorsed by Weatherbeeta.=0AWeatherbeeta, its employees, contr= actors or associates shall not be liable=0Afor direct, indirect or consequenti= al loss arising from transmission of this=0Amessage or any attachments=0A
= ------=_NextPart_000_0041_01C751A7.0E609F30--