Re: BUG #5028: CASE returns ELSE value always when type is"char"

Kevin Grittner <kevin.grittner@wicourts.gov>

From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Tom Lane" <tgl@sss.pgh.pa.us>, "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Cc: <pgsql-bugs@postgresql.org>,"Sam Mason" <sam@samason.me.uk>
Date: 2009-09-02T18:21:18Z
Lists: pgsql-bugs
I wrote: 
 
> A simple, self-contained example derived from the OP:
>  
> test=# create table t (c "char");
> CREATE TABLE
> test=# insert into t values ('a');
> INSERT 0 1
> test=# select case when c = 'a' then 'Hey' else c end from t;
>  c
> ---
>  H
> (1 row)
> 
> test=# select case when c = 'a' then 'Hey'::text else c end from t;
>   c
> -----
>  Hey
> (1 row)
 
And I'm not even sure how I'd explain the rules to someone.  (I guess
that's because I don't understand them, really, but the other way
sounds better....)
 
test=# drop table t;
DROP TABLE
test=# create table t (c varchar(2));
CREATE TABLE
test=# insert into t values ('a');
INSERT 0 1
test=# select case when c = 'a' then 'Hey' else c end from t;
  c
-----
 Hey
(1 row)

test=# select case when c = 'a' then 'Hey'::text else c end from t;
  c
-----
 Hey
(1 row)
 
-Kevin