Re: BUG #18594: CASE WHEN ELSE failing to return the expected output when the same colum is used in WHEN and ELSE

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Chris BSomething <xpusostomos@gmail.com>
Cc: PostgreSQL Bug List <pgsql-bugs@lists.postgresql.org>
Date: 2025-02-17T23:12:39Z
Lists: pgsql-bugs
On Mon, Feb 17, 2025 at 3:49 PM Chris BSomething <xpusostomos@gmail.com>
wrote:

> That sounds like a lot of words to justify an error that could be caught
> at parse time, that is actually never caught at all.  It seems to me that
> whatever type is inferred from a long constant string, it won't fit into a
> char... At least not without casting it. And therefore an error should come
> out.
>

I thought you were trying to convince people to modify the documentation?
This reads more like wanting to hack the parser to teach it forbidden
knowledge.

In any case I think this email report is closed and burying any discussion
about this material here just makes it harder for people to find.

David J.