Re: extend JSON_TABLE top level path expression

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: extend JSON_TABLE top level path expression
Date: 2025-11-28 04:32:51
Message-ID: CACJufxH0K-H7xDC94rh87+R7zX1qP8ZpYgLu+JwX6q3jCpnFuw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi.

https://stream.boxwatch.ru/docs/current/functions-json.html#FUNCTIONS-SQLJSON-TABLE
JSON_TABLE (
context_item, path_expression [ AS json_path_name ] [ PASSING {
value AS varname } [, ...] ]

I quickly realized I didn't have tests that path_expression is not String
A_Const and PASSING clause is not NULL. so I changed existing tests
to cover this
scenario.

The rest of the patch remains the same as v1.

--
jian
https://www.enterprisedb.com/

Attachment Content-Type Size
v2-0001-extend-JSON_TABLE-top-level-path-expression.patch text/x-patch 45.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ajin Cherian 2025-11-28 04:46:18 Re: Improve pg_sync_replication_slots() to wait for primary to advance
Previous Message Tom Lane 2025-11-28 04:27:53 Re: Simplify code building the LR conflict messages