| From: | "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Retrieving 'Credit' when 'C' |
| Date: | 2007-02-15 16:17:46 |
| Message-ID: | 55c095e90702150817m3e462817qa792dba0e1916885@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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' ?
Like:
On table:
When Type
2007-01-01 C
2007-01-02 C
2007-01-03 C
On SQL result
When Type
2007-01-01 CREDIT
2007-01-02 CREDIT
2007-01-03 CREDIT
Thanks in advande,
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rodrigo De León | 2007-02-15 16:28:10 | Re: Retrieving 'Credit' when 'C' |
| Previous Message | Michael Glaesemann | 2007-02-15 14:04:04 | Re: "for SELECT DISTINCT, ORDER BY expressions must appear in select list" - is that the standart or a limitation of postgresql? |