Re: Error when using array_agg with filter where clause in pg16 and pg17 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Error when using array_agg with filter where clause in pg16 and pg17
Date
Msg-id 112033.1744166186@sss.pgh.pa.us
Whole thread Raw
In response to Re: Error when using array_agg with filter where clause in pg16 and pg17  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Error when using array_agg with filter where clause in pg16 and pg17
List pgsql-bugs
David Rowley <dgrowleyml@gmail.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



pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: Error when using array_agg with filter where clause in pg16 and pg17
Next
From: David Rowley
Date:
Subject: Re: Error when using array_agg with filter where clause in pg16 and pg17