Re: Inclusion of json in list of standard data types

2025-12-08 Thread Tom Lane
Erik Wienhold 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 standa

Re: Virtual Generated Columns

2025-12-08 Thread Erik Wienhold
On 2025-12-05 14:57 +0100, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/17/ddl-generated-columns.html > Description: > > The documentation for generated columns in PostgreSQL versions prior to 18 > ment

Re: Inclusion of json in list of standard data types

2025-12-08 Thread Erik Wienhold
On 2025-12-06 19:27 +0100, Tom Lane wrote: > Bob Kline writes: > > Would there be any reason not to add "json" to the list of data types > > "specified by SQL" in the "Compatibility" box shown near the beginning > > of Chapter 8 ("Data Types") of the PostgreSQL documentation? > > Yeah, that seems

Virtual Generated Columns

2025-12-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ddl-generated-columns.html Description: The documentation for generated columns in PostgreSQL versions prior to 18 mention "virtual" columns, but as far as I can tell, this is not availabl