Re: Retrieving 'Credit' when 'C'

From: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>
To: "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Retrieving 'Credit' when 'C'
Date: 2007-02-15 16:44:36
Message-ID: 55c095e90702150844h3159bfbbx83c71b6910f4a88f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Ezequias

2007/2/15, Alvaro Herrera <alvherre(at)commandprompt(dot)com>:
>
> Ezequias Rodrigues da Rocha escribió:
> > 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 = 'C' then 'CREDIT' end
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message chrisj 2007-02-15 16:55:58 Re: can someone explain confusing array indexing nomenclature
Previous Message Alvaro Herrera 2007-02-15 16:30:14 Re: Retrieving 'Credit' when 'C'