Case with Char(1)

["Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com>]

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
---+-------
A | one
B | two
C | other

I know from all program languages that case do not apply to noun
sequencialiable (if this word exists) variable (like integers etc).

Any help would be greatfull.

Thanks in advance
Ezequias