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

Sam Mason <sam@samason.me.uk> writes:
> On Tue, Sep 01, 2009 at 05:49:25PM +0100, Sam Mason wrote:
>> PG could maybe throw an error to tell you this is
>> what is happening?

> Would something like the included patch be accepted?

ISTM this was debated once before and rejected.  However, there's a
proposal over here
http://archives.postgresql.org/pgsql-hackers/2009-08/msg02073.php
to tighten up what the "char" input functions will take, and maybe
throwing error for excess input would fit in with that.

            regards, tom lane