From: Vik Fearing <vik@postgresfriends.org>
To: Erki Eessaar <erki.eessaar@taltech.ee>
To: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Cc: Peter Eisentraut <peter@eisentraut.org>
Subject: Re: JSON type unsupported
Date: Tue, 26 Sep 2023 17:31:11 +0200
Message-ID: <d180d17c-c48c-762e-f647-48da195f3272@postgresfriends.org> (raw)
In-Reply-To: <AS8PR01MB82592A6675A14CE5E5FFFE5AFEC3A@AS8PR01MB8259.eurprd01.prod.exchangelabs.com>
References: <AS8PR01MB82592A6675A14CE5E5FFFE5AFEC3A@AS8PR01MB8259.eurprd01.prod.exchangelabs.com>
On 9/26/23 11:33, Erki Eessaar wrote:
> Hello
>
> According to Appendix D. SQL Conformance
>
> https://www.postgresql.org/docs/current/unsupported-features-sql-standard.html
>
> the feature T801 JSON data type is unsupported. However, PostgreSQL has data types JSON and JSONB. Here (http://peter.eisentraut.org/blog/2023/04/18/postgresql-and-sql-2023) it is also said that T801 is supported.
>
> Perhaps there are some technical details that I am not aware of. However, I wanted to point this out.
Thank you for pointing this out. Peter's blog is slightly misleading in
that we do have the JSON data type, but the T801 feature is far from
complete.
For example, we do not have the JSON_SERIALIZE(), JSON()[1],
JSON_SCALAR() functions. We don't have the IS JSON predicate, or a few
other things hiding behind T801.
All in all, I would not say we support the JSON data type the way the
standard intends, and therefore we should not claim to support T801.
[1] This is a fully specified parsing function, not just a cast like we
have today.
--
Vik Fearing
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: vik@postgresfriends.org, erki.eessaar@taltech.ee, pgsql-docs@lists.postgresql.org, peter@eisentraut.org
Subject: Re: JSON type unsupported
In-Reply-To: <d180d17c-c48c-762e-f647-48da195f3272@postgresfriends.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox