Re: function 'IS JSON ARRAY' not identified

Tom,
thanks for taking a look at this so quickly. Shame homebrew is so behind, but this is a kind of a relief.
Regards,
Antonio
________________________________
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Sent: Monday, June 2, 2025 11:19 AM
To: Badia, Antonio <antonio(dot)badia(at)louisville(dot)edu>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: function 'IS JSON ARRAY' not identified

CAUTION: This email originated from outside of our organization. Do not click links, open attachments, or respond unless you recognize the sender's email address and know the contents are safe.

"Badia, Antonio" <antonio(dot)badia(at)louisville(dot)edu> writes:
> When running query
> select d.data - 'keya' || jsonb_build_object('keya', jsonb_array_elements(d.data::jsonb-> 'keya'))
> from "Jsondata2" as d
> where jsonb_exists(d.data '$.keya') and d.data->'keya' is not null and d.data->'keya' IS JSON ARRAY;
> I get the error message:
> ERROR: syntax error at or near "JSON" LINE 3: ... d.data->'keya' is not null and d.data->'keya' IS JSON ARRAY... ^
> SQL state: 42601
> Character: 213

> Running Postgresql on MacOS (Sequoia 15.5), installed via homebrew:
> antonio(at)mac POSTGRES % psql
> psql (14.18 (Homebrew), server 14.17 (Homebrew))

IS JSON ARRAY was added in PG v16.

regards, tom lane