Case with Char(1) - Mailing list pgsql-sql

From Ezequias Rodrigues da Rocha
Subject Case with Char(1)
Date
Msg-id 55c095e90702280502x3673fe6g67e7cb5de714356f@mail.gmail.com
Whole thread Raw
Responses Re: Case with Char(1)  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: Case with Char(1)  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: Conditional NOT NULL constraint
Next
From: Andrew Sullivan
Date:
Subject: Re: Case with Char(1)