It's practically ripped straight from PostresSQL documentation.

PostgreSQL already supports:

* ORDER BY in grouped table (F868)

* GREATEST and LEAST (T054)

* String padding functions (T055)

* Multi-character TRIM functions (T056)

* Optional string types maximum length (T081)

* Enhanced cycle mark values (T133)

* JSON data type (T801)

* Enhanced JSON data type (T802)

* String-based JSON (T803)

* SQL/JSON simplified accessor (T860–T864)

The upcoming release of PostgreSQL 16 will have:

* Non-decimal integer literals (T661)

* Underscores in numeric literals (T662)

PostgreSQL currently lacks:

* UNIQUE null treatment (F292)

* ANY_VALUE (T626)

* Hex integer literals in SQL/JSON path language (T840)

* SQL/JSON item methods (T865–T878)

* JSON comparison (T879–T882) - though the nonstandard JSONB has this

* Property Graph Queries

---

As with many standards, the SQL standard likes to include things that DBMSs already have in the wild and have found practically useful.

Postgres has support for specifying NULL behavior in UNIQUE constraints since version 15.0 (released in 2022), with the same syntax as described in the article.

See the end of the documentation on unique constraints: https://www.postgresql.org/docs/15/ddl-constraints.html#DDL-...

Ooh, fancy

I'm out of date :)

> SQL/JSON simplified accessor (T860–T864)

Where is the doc for this one? I can find Postgres’ own JSON(B) operators, as well as jsonpath (sql/json path language) support, but not SQL-level json paths, specifically the dot syntax.

Yeah, postgres uses proprietary syntax for this AFAIK. Would be nice to see t860-t864 supported.

Then there's the whole graph data stuff that seems to come straight from Oracle?

https://pgql-lang.org/

Man, there's few pieces of software that I love quite like Postgres.

Some of this has already implemented in PostgreSQL 9.6! lpad / ltrim, for example.