pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andres Freund <andres@anarazel.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andrew Gierth <andrew@tao11.riddles.org.uk>
Cc: pg@mattyw.net
Cc: 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
Date: Tue, 30 Oct 2018 10:44:11 -0700
Message-ID: <20181030174411.ryzrnzfjnuveknf6@alap3.anarazel.de> (raw)
In-Reply-To: <15342.1540906254@sss.pgh.pa.us>
References: <15471-1117f49271989bad@postgresql.org>
	<8112.1540900775@sss.pgh.pa.us>
	<87efc77gh2.fsf@news-spur.riddles.org.uk>
	<15342.1540906254@sss.pgh.pa.us>

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




view thread (6+ messages)

Message-ID: <20181030174411.ryzrnzfjnuveknf6@alap3.anarazel.de>
Permalink:  ../20181030174411.ryzrnzfjnuveknf6@alap3.anarazel.de/
Also on:    postgresql.org/message-id/20181030174411.ryzrnzfjnuveknf6@alap3.anarazel.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: andres@anarazel.de, tgl@sss.pgh.pa.us, 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
  In-Reply-To: <20181030174411.ryzrnzfjnuveknf6@alap3.anarazel.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox