public inbox for pgsql-docs@postgresql.org  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Erik Wienhold <ewie@ewie.name>
Cc: Bob Kline <bkline@rksystems.com>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Inclusion of json in list of standard data types
Date: Mon, 08 Dec 2025 14:36:43 -0500
Message-ID: <3100801.1765222603@sss.pgh.pa.us> (raw)
In-Reply-To: <31bad2c4-1876-4cfe-9463-08f4b02bf536@ewie.name>
References: <CAGjKmVoP4qVeJgkaBtQ6L46+OLARzmym53uQGhp5COw4wp65yQ@mail.gmail.com>
	<2326014.1765045678@sss.pgh.pa.us>
	<31bad2c4-1876-4cfe-9463-08f4b02bf536@ewie.name>

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, ewie@ewie.name, bkline@rksystems.com, pgsql-docs@lists.postgresql.org
  Subject: Re: Inclusion of json in list of standard data types
  In-Reply-To: <3100801.1765222603@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox