| 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.
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-extend-JSON_TABLE-top-level-path-expression.patch | text/x-patch | 45.2 KB |
| 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 |