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