Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 7F0849FBE10
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 15 Feb 2007 12:44:50 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 51371-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Thu, 15 Feb 2007 12:44:45 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175])
	by postgresql.org (Postfix) with ESMTP id 0C9C29FB971
	for <pgsql-sql@postgresql.org>; Thu, 15 Feb 2007 12:44:40 -0400 (AST)
Received: by ug-out-1314.google.com with SMTP id k3so193771ugf
	for <pgsql-sql@postgresql.org>; Thu, 15 Feb 2007 08:44:36 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
	b=uZ5/aFWaR7pSLmc7SUbFgzqylEVzLimkHSpMv1ksTuqlKa9J2rPeUZKo1QoUuRjfnJGiWofVDZKZJ+QN9CBfpbe2FhVi1UzDQ7AgBHR9lN9Ym3q11OsCy9qsasOm+lozLskpfBjhewg2yORAxESPFrzTO1T/l0C29sCXg+t+6e8=
Received: by 10.66.243.4 with SMTP id q4mr1875274ugh.1171557876843;
	Thu, 15 Feb 2007 08:44:36 -0800 (PST)
Received: by 10.66.217.13 with HTTP; Thu, 15 Feb 2007 08:44:36 -0800 (PST)
Message-ID: <55c095e90702150844h3159bfbbx83c71b6910f4a88f@mail.gmail.com>
Date: Thu, 15 Feb 2007 13:44:36 -0300
From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
To: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>,
	pgsql-sql@postgresql.org
Subject: Re: Retrieving 'Credit' when 'C'
In-Reply-To: <20070215163014.GP4682@alvh.no-ip.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_132773_2411065.1171557876766"
References: <55c095e90702150817m3e462817qa792dba0e1916885@mail.gmail.com>
	<20070215163014.GP4682@alvh.no-ip.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.298 tagged_above=0 required=5 tests=AWL, BAYES_50,
	HTML_50_60, HTML_MESSAGE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200702/168
X-Sequence-Number: 27502

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

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

Ezequias

2007/2/15, Alvaro Herrera <alvherre@commandprompt.com>:
>
> Ezequias Rodrigues da Rocha escribi=F3:
> > 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' ?
>
> case when column =3D 'C' then 'CREDIT' end
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>



--=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_132773_2411065.1171557876766
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Just a question, where to put it ? I didn&#39;t notice yet.<br><br><span st=
yle=3D"font-weight: bold;">Ezequias</span><br><br><div><span class=3D"gmail=
_quote">2007/2/15, Alvaro Herrera &lt;<a href=3D"mailto:alvherre@commandpro=
mpt.com">
alvherre@commandprompt.com</a>&gt;:</span><blockquote class=3D"gmail_quote"=
 style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.=
8ex; padding-left: 1ex;">Ezequias Rodrigues da Rocha escribi=F3:<br>&gt; He=
llo,
<br>&gt;<br>&gt; Does anyone know how to make a Select that even having a C=
har(1) with the<br>&gt; letter C the statement makes the rows appearing &#3=
9;CREDIT&#39; ?<br><br>case when column =3D &#39;C&#39; then &#39;CREDIT&#3=
9; end
<br><br>--<br>Alvaro Herrera&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;<a hr=
ef=3D"http://www.CommandPrompt.com/">http://www.CommandPrompt.com/</a><br>T=
he PostgreSQL Company - Command Prompt, Inc.<br></blockquote></div><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>&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Atenciosamente (Sincerel=
y)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&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_132773_2411065.1171557876766--