Re: Inclusion of json in list of standard data types

Erik Wienhold <ewie@ewie.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