Hi list,
it is possible to use case with character (1) ?
I am having problems to formate the SQL statement.
I have:
SELECT * FROM test;
a
---
A
B
C
SELECT a,
CASE WHEN a='A' THEN 'one'
WHEN a='B' THEN 'two'
ELSE 'other'
END
FROM test;
a | case
On Wed, Feb 28, 2007 at 10:02:38AM -0300, Ezequias Rodrigues da Rocha wrote:
Hi list,
it is possible to use case with character (1) ?
I am having problems to formate the SQL statement.
Your example looked like it worked.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
Users never remark, Wow,
Am Mittwoch, 28. Februar 2007 14:02 schrieb Ezequias Rodrigues da Rocha:
it is possible to use case with character (1) ?
Have you tried it?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 7: You can help
Now it is working. Thank you for your interest.
Ezequias
2007/2/28, Andrew Sullivan [EMAIL PROTECTED]:
On Wed, Feb 28, 2007 at 10:02:38AM -0300, Ezequias Rodrigues da Rocha wrote:
Hi list,
it is possible to use case with character (1) ?
I am having problems to formate the SQL statement.