Re: Error when using array_agg with filter where clause in pg16 and pg17

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: Kaimeh <kkaimeh(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Error when using array_agg with filter where clause in pg16 and pg17
Date: 2025-04-09 02:36:26
Message-ID: 112033.1744166186@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

David Rowley <dgrowleyml(at)gmail(dot)com> writes:
> I'm not following why my in method if the planner chooses a poor plan
> is any different from the planner choosing a poor plan for anything
> else because the stats or costs aren't a good reflection of reality.

Well, we hope we'll usually pick the right thing. But upthread
you were complaining that any change might be a regression, or
at least that's how I read it.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2025-04-09 02:55:33 Re: Error when using array_agg with filter where clause in pg16 and pg17
Previous Message David Rowley 2025-04-09 01:50:48 Re: Error when using array_agg with filter where clause in pg16 and pg17