Re: Retrieving 'Credit' when 'C' - Mailing list pgsql-sql

From Ezequias Rodrigues da Rocha
Subject Re: Retrieving 'Credit' when 'C'
Date
Msg-id 55c095e90702150844h3159bfbbx83c71b6910f4a88f@mail.gmail.com
Whole thread Raw
In response to Re: Retrieving 'Credit' when 'C'  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Retrieving 'Credit' when 'C'  ("Phillip Smith" <phillip.smith@weatherbeeta.com.au>)
List pgsql-sql
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ó:
> 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/

pgsql-sql by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Retrieving 'Credit' when 'C'
Next
From: chrisj
Date:
Subject: Re: can someone explain confusing array indexing nomenclature