Re: pg18 bug? SELECT query doesn't work - Mailing list pgsql-general

> On Jan 6, 2026, at 10:22 AM, Eric Ridge <eebbrr@gmail.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
animalilike '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
animalilike '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