Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Cc: pgsql-bugs@postgresql.org, "Sam Mason" <sam@samason.me.uk>
Date: 2009-09-04T19:19:10Z
Lists: pgsql-bugs 
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Only, I guess, because of the name.  If it weren't called "char" I
> guess I wouldn't be concerned about people expecting it to behave
> something like char.  If "char" behaved more like char, the 'xxx'
> literal wouldn't be taken as input to the type in the above CASE
> statement.

I'm not certain what you're trying to say, but the above is complete
nonsense ...

			regards, tom lane