Erik Wienhold <[email protected]> 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
