Horton

Re: SQL/JSON revisited

Jonathan S. Katz <jkatz@postgresql.org>

View thread View on postgr.es
From: "Jonathan S. Katz" <jkatz@postgresql.org>
To: Nikita Malakhov <hukutoc@gmail.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Amit Langote <amitlangote09@gmail.com>, Alexander Lakhin <exclusion@gmail.com>, Erik Rijkers <er@xs4all.nl>, Andrew Dunstan <andrew@dunslane.net>, Peter Eisentraut <peter.eisentraut@enterprisedb.com>, Andres Freund <andres@anarazel.de>, vignesh C <vignesh21@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, e.indrupskaya@postgrespro.ru
Date: 2023-04-04T19:44:05Z
Lists: pgsql-hackers 
On 4/4/23 3:40 PM, Nikita Malakhov wrote:
> Hi hackers!
> 
> The latest SQL standard contains dot notation for JSON. Are there any 
> plans to include it into Pg 16?
> Or maybe we should start a separate thread for it?

I would recommend starting a new thread to discuss the dot notation.

Thanks,

Jonathan

Commits

  1. Add SQL/JSON query functions

  2. Add soft error handling to some expression nodes

  3. Adjust populate_record_field() to handle errors softly

  4. Refactor code used by jsonpath executor to fetch variables

  5. Code review for recent SQL/JSON commits

  6. Fix inconsistencies and style issues in new SQL/JSON code

  7. Don't install postmaster symlink anymore

  8. Revert SQL/JSON features

  9. Doc: standardize markup a bit more.