pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedJSON type unsupported
5+ messages / 4 participants
[nested] [flat]
* JSON type unsupported
@ 2023-09-26 09:33 Erki Eessaar <erki.eessaar@taltech.ee>
0 siblings, 1 reply; 5+ messages in thread
From: Erki Eessaar @ 2023-09-26 09:33 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
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.
Best regards
Erki Eessaar
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: JSON type unsupported
@ 2023-09-26 15:31 Vik Fearing <vik@postgresfriends.org>
parent: Erki Eessaar <erki.eessaar@taltech.ee>
0 siblings, 2 replies; 5+ messages in thread
From: Vik Fearing @ 2023-09-26 15:31 UTC (permalink / raw)
To: Erki Eessaar <erki.eessaar@taltech.ee>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>; +Cc: Peter Eisentraut <peter@eisentraut.org>
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: JSON type unsupported
@ 2023-09-26 17:24 Tom Lane <tgl@sss.pgh.pa.us>
parent: Vik Fearing <vik@postgresfriends.org>
1 sibling, 0 replies; 5+ messages in thread
From: Tom Lane @ 2023-09-26 17:24 UTC (permalink / raw)
To: Vik Fearing <vik@postgresfriends.org>; +Cc: Erki Eessaar <erki.eessaar@taltech.ee>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>; Peter Eisentraut <peter@eisentraut.org>
Vik Fearing <vik@postgresfriends.org> writes:
> 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.
Agreed, but should we say "partial support", as we do for some other
feature identifiers?
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: JSON type unsupported
@ 2023-10-06 10:57 Peter Eisentraut <peter@eisentraut.org>
parent: Vik Fearing <vik@postgresfriends.org>
1 sibling, 1 reply; 5+ messages in thread
From: Peter Eisentraut @ 2023-10-06 10:57 UTC (permalink / raw)
To: Vik Fearing <vik@postgresfriends.org>; Erki Eessaar <erki.eessaar@taltech.ee>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
On 26.09.23 17:31, Vik Fearing wrote:
> 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.
AFAICT, commit 03734a7fed, which is new in master, adds exactly those,
so maybe we could toggle this feature to supported?
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: JSON type unsupported
@ 2023-10-06 11:50 Vik Fearing <vik@postgresfriends.org>
parent: Peter Eisentraut <peter@eisentraut.org>
0 siblings, 0 replies; 5+ messages in thread
From: Vik Fearing @ 2023-10-06 11:50 UTC (permalink / raw)
To: Peter Eisentraut <peter@eisentraut.org>; Erki Eessaar <erki.eessaar@taltech.ee>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
On 10/6/23 11:57, Peter Eisentraut wrote:
> On 26.09.23 17:31, Vik Fearing wrote:
>> 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.
>
> AFAICT, commit 03734a7fed, which is new in master, adds exactly those,
> so maybe we could toggle this feature to supported?
That is better than before, but even those functions are not complete.
I am okay with flipping to supported but with a note saying there are
many subfeatures missing.
--
Vik Fearing
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2023-10-06 11:50 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-09-26 09:33 JSON type unsupported Erki Eessaar <erki.eessaar@taltech.ee>
2023-09-26 15:31 ` Vik Fearing <vik@postgresfriends.org>
2023-09-26 17:24 ` Tom Lane <tgl@sss.pgh.pa.us>
2023-10-06 10:57 ` Peter Eisentraut <peter@eisentraut.org>
2023-10-06 11:50 ` Vik Fearing <vik@postgresfriends.org>
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