JSON_ARRAYAGG() - Behaves in the same way as json_array but as an aggregate function so it only takes one value_expression parameter. SELECT json_arrayagg(v NULL ON NULL) FROM (VALUES(2),(1),(3),(NULL)) t(v); json_arrayagg---[2, 1, 3, null] JSON_OBJECT() - Constructs ...
Streaming replication, Hot standby more detailsBuilt-in replication in PostgreSQL 9.0 STRING_AGG -- this is a nice to have so you don't need to do array_to_string(ARRAY_AGG(somefield), '\') and with the ORDER BY feature its even better. Conditional triggers - triggers that only run ...