Re: Inclusion of json in list of standard data types

Erik Wienhold <ewie(at)ewie(dot)name> writes:
> But does Postgres' json type really map to the JSON type defined by
> SQL:2023? jsonb appears to be closer to that, although I don't have
> access to that particular version of the standard. Peter wrote [1]
> about the compatibility with SQL:2023 and noted that the standard maps
> more readily to jsonb (see 3rd bullet point in the notes section) and
> features T879–T882 still only apply to jsonb.

Well, there is the weasel wording right at the start of that <note>:

The following types (or spellings thereof) are specified by SQL:

This note also doesn't get into the rather large semantic gap between
what SQL says TIMESTAMP WITH TIME ZONE is and what timestamptz
actually does. I think the point of the note is mostly to say that
"you have some hope of interoperability with other DBMSes if you
use these types".

regards, tom lane