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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq