News for hackers. Stuff that matters.
Re:PostgreSQL 16 Released by MuffinFlavored on Thursday September 14, 2023 @10:09AM (#37509300)
> SQL/JSON constructors

Like these?

> Adds SQL/JSON constructors, including JSON_ARRAY(), JSON_ARRAYAGG(), JSON_OBJECT(), and JSON_OBJECTAGG().

Not sure what SQL/JSON identity functions relate to

Re:PostgreSQL 16 Released by zkomp on Thursday September 14, 2023 @10:42AM (#37509664)
identity probably refers to the ’IS’:

SELECT js, js IS JSON OBJECT "object?", js IS JSON ARRAY "array?", js IS JSON ARRAY WITH UNIQUE KEYS "array w. UK?", js IS JSON ARRAY WITHOUT UNIQUE KEYS "array w/o UK?" FROM (VALUES ('[{"a":"1"}, {"b":"2","b":"3"}]')) foo(js);