Re: Retrieving 'Credit' when 'C'

Perfect,

I learn this lesson now. This case is quite good.

My Best Regards
Ezequias

2007/2/15, Phillip Smith <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>:
>
> SELECT when,
>
> CASE WHEN type = '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(at)postgresql(dot)org [mailto:
> pgsql-sql-owner(at)postgresql(dot)org] *On Behalf Of *Ezequias Rodrigues da Rocha
> *Sent:* Friday, 16 February 2007 03:45
> *To:* Ezequias Rodrigues da Rocha; pgsql-sql(at)postgresql(dot)org
> *Subject:* Re: [SQL] Retrieving 'Credit' when 'C'
>
>
>
> Just a question, where to put it ? I didn't notice yet.
>
> ********************Confidentiality and Privilege
> Notice********************
>
> The material contained in this message is privileged and confidential to
> the addressee. If you are not the addressee indicated in this message or
> responsible for delivery of the message to such person, you may not copy or
> deliver this message to anyone, and you should destroy it and kindly notify
> the sender by reply email.
>
> Information in this message that does not relate to the official business
> of Weatherbeeta must be treated as neither given nor endorsed by
> Weatherbeeta. Weatherbeeta, its employees, contractors or associates shall
> not be liable for direct, indirect or consequential loss arising from
> transmission of this message or any attachments
>
>

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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/