In today's episode, we take a look at the SQL/JSON features in Postgres 15. Postgres 15 will most likely be released in September or October, so it's still quite a way until we can actually use this on a production server. However, a couple of days ago, the Postgres 15 feature freeze occurred, which means we now have a good sense for which functionality will make it into this next Postgres release.
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
/ pganalyze
📑 What we have discussed in this episode of 5mins of Postgres:
Waiting for PostgreSQL 15 – Documentation for SQL/JSON features: https://www.depesz.com/2022/04/08/wai...
SQL/JSON constructors: https://www.depesz.com/2022/03/31/wai...
IS JSON predicate: https://www.depesz.com/2022/04/01/wai...
SQL/JSON query functions: https://www.depesz.com/2022/04/01/wai...
JSON_TABLE: https://www.depesz.com/2022/04/06/wai...
JSON Functions and Operators - JSON_TABLE: https://www.postgresql.org/docs/devel...