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
---ABC
SELECT a, CASE WHEN a='A' THEN 'one' WHEN a='B' THEN 'two' ELSE 'other' END FROM test;
a | case
---+-------A | oneB | twoC | 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