Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 644BB9FB648
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 15 Feb 2007 12:18:05 -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 83846-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 15 Feb 2007 12:17:47 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.225])
	by postgresql.org (Postfix) with ESMTP id 30C169FB624
	for <pgsql-sql@postgresql.org>; Thu, 15 Feb 2007 12:17:47 -0400 (AST)
Received: by wx-out-0506.google.com with SMTP id i28so726516wxd
	for <pgsql-sql@postgresql.org>; Thu, 15 Feb 2007 08:17:46 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=qE7gzMKzbJoUTMQUcZkWfVCC6iu5/fpqio9yDJ/Y3tFkGTJx1tsfTTrZc0poQLAiIJf2+/OGFaTB5C2cip9+XGyZx39YdLlaKb2V+wU+Vqza/PwQaGmW0/25JGrlEJs05U1sjjILf+ZTh7ck1u/OHnIEzw51ylNYJfl/0+gqtcE=
Received: by 10.90.27.15 with SMTP id a15mr2562359aga.1171556266705;
	Thu, 15 Feb 2007 08:17:46 -0800 (PST)
Received: by 10.66.217.13 with HTTP; Thu, 15 Feb 2007 08:17:46 -0800 (PST)
Message-ID: <55c095e90702150817m3e462817qa792dba0e1916885@mail.gmail.com>
Date: Thu, 15 Feb 2007 13:17:46 -0300
From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Retrieving 'Credit' when 'C'
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_132200_6676879.1171556266611"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.311 tagged_above=0 required=5 tests=AWL, BAYES_50,
	HTML_50_60, HTML_MESSAGE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200702/165
X-Sequence-Number: 27499

------=_Part_132200_6676879.1171556266611
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello,

Does anyone know how to make a Select that even having a Char(1) with the
letter C the statement makes the rows appearing 'CREDIT' ?

Like:
 On table:

When         Type
2007-01-01    C
2007-01-02    C
2007-01-03    C

On SQL result
When         Type
2007-01-01    CREDIT
2007-01-02    CREDIT
2007-01-03    CREDIT

Thanks in advande,


--=20
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
A pior das democracias ainda =E9 melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

------=_Part_132200_6676879.1171556266611
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello,<br><br>Does anyone know how to make a Select that even having a Char=
(1) with the letter C the statement makes the rows appearing &#39;CREDIT&#3=
9; ?<br><br>Like: <br>&nbsp;On table:<br><br>When&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp; Type<br>2007-01-01&nbsp; &nbsp; C
<br>2007-01-02&nbsp;&nbsp;&nbsp; C<br>2007-01-03 &nbsp;&nbsp; C<br><br>On S=
QL result<br>When&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type<br>
2007-01-01&nbsp; &nbsp; CREDIT<br>
2007-01-02&nbsp;&nbsp;&nbsp; CREDIT<br>
2007-01-03 &nbsp;&nbsp; CREDIT<br><br>Thanks in advande,<br>
<br clear=3D"all"><br>-- <br> =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Atenc=
iosamente (Sincerely)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;Ezequias Rodrigues da Rocha<br> =3D-=3D-=3D-=3D-=3D-=3D-=
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
<br>A pior das democracias ainda =E9 melhor do que a melhor das ditaduras<b=
r>The worst of democracies is still better than the better of dictatorships=
<br><a href=3D"http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blo=
gspot.com/
</a>

------=_Part_132200_6676879.1171556266611--