| From: | jian he <jian(dot)universality(at)gmail(dot)com> |
|---|---|
| To: | Amit Langote <amitlangote09(at)gmail(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Andres Freund <andres(at)anarazel(dot)de>, Erik Rijkers <er(at)xs4all(dot)nl>, Andrew Dunstan <andrew(at)dunslane(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: remaining sql/json patches |
| Date: | 2024-01-25 09:20:00 |
| Message-ID: | CACJufxHUV-rOFex=VTLO-5y0y2gUg6LFQw59HFHUpZZxbcHEeQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 9.16.4. JSON_TABLE
`
name type FORMAT JSON [ENCODING UTF8] [ PATH json_path_specification ]
Inserts a composite SQL/JSON item into the output row
`
i am not sure "Inserts a composite SQL/JSON item into the output row"
I think it means, for any type's typecategory is TYPCATEGORY_STRING,
if FORMAT JSON is specified explicitly, the output value (text type)
will be legal
json type representation.
I also did a minor refactor on JSON_VALUE_OP, jsexpr->omit_quotes.
| Attachment | Content-Type | Size |
|---|---|---|
| minor_fix_v38.diff | application/x-patch | 1023 bytes |
| v1-0001-refactor-sqljson_jsontable-related-tests.no-cfbot | application/octet-stream | 25.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wei Wang (Fujitsu) | 2024-01-25 09:26:42 | Fix inappropriate comments in function ReplicationSlotAcquire |
| Previous Message | Amit Langote | 2024-01-25 09:09:42 | Re: remaining sql/json patches |