Re: pg18 bug? SELECT query doesn't work

> On Jan 6, 2026, at 10:22 AM, Eric Ridge <eebbrr(at)gmail(dot)com> wrote:
>
> 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
--------
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