Waiting for PostgreSQL 15 – Documentation for SQL/JSON features

On 8th of April 2022, Andrew Dunstan committed patch:

Documentation for SQL/JSON features
This documents the features added in commits f79b803dcc, f4fb45d15c,
33a377608f, 1a36bc9dba, 606948b058, 49082c2cc3, 4e34747c88, and
I have cleaned up the aggregate section of the submitted docs, but there
is still a deal of copy editing required. However, I thought it best to
have some documentation sooner rather than later so testers can have a
better idea what they are playing with.
Nikita Glukhov
Reviewers have included (in no particular order) Andres Freund, Alexander
Korotkov, Pavel Stehule, Andrew Alsup, Erik Rijkers, Zhihong Yu,
Himanshu Upadhyaya, Daniel Gustafsson, Justin Pryzby.
Discussion: https://postgr.es/m/cd0bb935-0158-78a7-08b5-904886deac4b@postgrespro.ru
Discussion: https://postgr.es/m/7e2cb85d-24cf-4abb-30a5-1a33715959bd@postgrespro.ru

Reading the patch to docs is not really trivial. But I looked at what was changed, and figured that the changes went generally to two files:

Specifically, in the first doc, this change added whole section SQL/JSON Functions and Expressions.

In case of aggregate doc, there are more changes:

  • Added docs about json_agg_strict and jsonbjson_agg_strict
  • Added docs about json_object_agg_strict and jsonbjson_object_agg_strict
  • Added docs about json_object_agg_unique and jsonbjson_object_agg_unique
  • Added docs about json_object_agg_unique_strict and jsonbjson_object_agg_unique_strict
  • Added note about JSON_OBJECTAGG and JSON_ARRAYAGG constructors

This is great. Lots of stuff to read that will explain the SQL/JSON changes in detail.

Thanks a lot to everybody involved. That was huge project, and the outcome is amazing.