From: Eric Ridge <eebbrr@gmail.com>
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.500.181.1.5\))
Subject: Re: pg18 bug?  SELECT query doesn't work
Date: Tue, 6 Jan 2026 10:52:56 -0500
References: <7900964C-F99E-481E-BEE5-4338774CEB9F@gmail.com>
To: pgsql-general <pgsql-general@postgresql.org>
In-Reply-To: <7900964C-F99E-481E-BEE5-4338774CEB9F@gmail.com>
Message-Id: <C7FCAD3A-9859-4CCB-95DE-62ECF1368331@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/C7FCAD3A-9859-4CCB-95DE-62ECF1368331%40gmail.com>
Precedence: bulk

> On Jan 6, 2026, at 10:22=E2=80=AFAM, Eric Ridge <eebbrr@gmail.com> =
wrote:
>=20
> Here's a reduced test case:

Here's an even more reduced test case.  No tables or data:

# SELECT * FROM (SELECT upper(unnest(ARRAY['cat', 'dog'])) as animal =
FROM generate_series(1, 10) GROUP BY 1) x WHERE animal ilike 'c%';

pg15 returns:

 animal =20
--------
 CAT
(1 row)

and pg18 says:

# SELECT * FROM (SELECT upper(unnest(ARRAY['cat', 'dog'])) as animal =
FROM generate_series(1, 10) GROUP BY 1) x WHERE animal ilike 'c%';
ERROR:  set-valued function called in context that cannot accept a set
LINE 1: SELECT * FROM (SELECT upper(unnest(ARRAY['cat', 'dog'])) as ...
                                    ^

Thanks!

eric