Date: Tue, 30 Oct 2018 10:44:11 -0700
From: Andres Freund <andres@anarazel.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andrew Gierth <andrew@tao11.riddles.org.uk>, pg@mattyw.net,
	pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #15471: psql 11 array concatenation in CASE takes on values
 from the CASE expression when using enum_range
Message-ID: <20181030174411.ryzrnzfjnuveknf6@alap3.anarazel.de>
References: <15471-1117f49271989bad@postgresql.org>
 <8112.1540900775@sss.pgh.pa.us>
 <87efc77gh2.fsf@news-spur.riddles.org.uk>
 <15342.1540906254@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <15342.1540906254@sss.pgh.pa.us>
Precedence: bulk

Hi,

On 2018-10-30 09:30:54 -0400, Tom Lane wrote:
> Good guess but I don't think that changed anything.  It looks to me
> like the culprit is commit c12d570fa, so it's my bug not Andres' :-(.

:)


> This is all some more fuel for the idea that we need a less messy
> substitute for CaseTestExpr.  As it happens, I was just fooling with
> that yesterday, and hope to have something to post soon.  But it'll
> be too invasive to back-patch.  I'll try to fix this particular
> problem more locally.

Yea, I agree we need something better there.  I happened to also play
around with that (more from the angle that we'd want similar
infrastructure for the SQL function inlining case we talked about) on
the long flights back from .eu yesterday, but didn't get that far. Will
wait till you have posted something.

Greetings,

Andres Freund