MIME-Version: 1.0
References: <7900964C-F99E-481E-BEE5-4338774CEB9F@gmail.com>
In-Reply-To: <7900964C-F99E-481E-BEE5-4338774CEB9F@gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 6 Jan 2026 09:04:01 -0700
Message-ID: <CAKFQuwbQj6kLxiz=Ft=ykM2s+H0ytCL7C+Cg1G=7W8ifhFi0Ow@mail.gmail.com>
Subject: Re: pg18 bug? SELECT query doesn't work
To: Eric Ridge <eebbrr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002323450647ba5596"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbQj6kLxiz%3DFt%3DykM2s%2BH0ytCL7C%2BCg1G%3D7W8ifhFi0Ow%40mail.gmail.com>
Precedence: bulk

--0000000000002323450647ba5596
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Jan 6, 2026 at 8:22=E2=80=AFAM Eric Ridge <eebbrr@gmail.com> wrote:

> drop table if exists wth;
> create table wth (id serial8, json_data json);
> insert into wth (json_data) values ('[{"animal": "cats"}, {"animal":
> "dogs"}]');
>
> -- this ERRORs on pg18
> select animal
> from (select upper(json_array_elements(json_data) ->> 'animal') animal,
> count(*) from wth group by 1) x
> where animal ilike 'c%';
>
> On pg18 I'm presented with:
>
> ERROR:  set-valued function called in context that cannot accept a set
> LINE 1: select animal from (select upper(json_array_elements(json_da...
>
> Just thought I'd bring this to y'alls attention.
>
>
It was an intentional change.  You now should be putting set-producing
functions into the FROM clause of a query or subquery.  A lateral join is
often required.

David J.

--0000000000002323450647ba5596
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Tue, Jan 6, 2026 at 8:22=E2=80=AFAM Eric Ridge &lt;<a h=
ref=3D"mailto:eebbrr@gmail.com">eebbrr@gmail.com</a>&gt; wrote:</span></div=
></div><div class=3D"gmail_quote gmail_quote_container"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">drop table if exists wth;<br>
create table wth (id serial8, json_data json);<br>
insert into wth (json_data) values (&#39;[{&quot;animal&quot;: &quot;cats&q=
uot;}, {&quot;animal&quot;: &quot;dogs&quot;}]&#39;);<br>
<br>
-- this ERRORs on pg18<br>
select animal<br>
from (select upper(json_array_elements(json_data) -&gt;&gt; &#39;animal&#39=
;) animal, count(*) from wth group by 1) x<br>
where animal ilike &#39;c%&#39;;<br><br>
On pg18 I&#39;m presented with:<br>
<br>
ERROR:=C2=A0 set-valued function called in context that cannot accept a set=
<br>
LINE 1: select animal from (select upper(json_array_elements(json_da...<br>=
<br>
Just thought I&#39;d bring this to y&#39;alls attention.<br><br></blockquot=
e><div><br></div><div class=3D"gmail_default" style=3D"font-family:arial,he=
lvetica,sans-serif">It was an intentional=C2=A0change.=C2=A0 You now should=
 be putting set-producing functions into the FROM clause of a query or subq=
uery.=C2=A0 A lateral join is often required.</div><div class=3D"gmail_defa=
ult" style=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">David J=
.</div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sa=
ns-serif"><br></div></div></div>

--0000000000002323450647ba5596--