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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-bugs(at)postgresql(dot)org, "Sam Mason" <sam(at)samason(dot)me(dot)uk>
Subject: Re: BUG #5028: CASE returns ELSE value always when type is "char"
Date: 2009-09-04 19:19:10
Message-ID: 13731.1252091950@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2009-09-04 19:32:17 Re: BUG #5028: CASE returns ELSE value always when type is "char"
Previous Message Kevin Grittner 2009-09-04 19:01:07 Re: BUG #5028: CASE returns ELSE value always when type is "char"