Re: Retrieving 'Credit' when 'C'

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Ezequias Rodrigues da Rocha <ezequias(dot)rocha(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Retrieving 'Credit' when 'C'
Date: 2007-02-15 16:30:14
Message-ID: 20070215163014.GP4682@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ezequias Rodrigues da Rocha 2007-02-15 16:44:36 Re: Retrieving 'Credit' when 'C'
Previous Message Rodrigo De León 2007-02-15 16:28:10 Re: Retrieving 'Credit' when 'C'