Re: PostgreSQL 17 Beta 1 release announcement draft

[Jonathan S. Katz]

On 5/20/24 8:31 AM, jian he wrote:

release note (https://momjian.us/pgsql_docs/release-17.html)
is
"Add jsonpath methods to convert JSON values to other JSON data types
(Jeevan Chalke)"

Additionally, PostgreSQL 17 adds more functionality to its `jsonpath` 
implementation, including the ability to convert JSON values to different data 
types.

so, I am not sure this is 100% correct.

Maybe we can rephrase it like:

Additionally, PostgreSQL 17 adds more functionality to its `jsonpath` 
implementation, including the ability to convert JSON values to other JSON data 
types.

The release note goes on to state:

==

==





Thanks,

Jonathan

[1] https://www.postgresql.org/docs/devel/functions-json.html

The jsonpath methods are .bigint(), .boolean(), .date(), .decimal([precision [, scale]]), .integer(), .number(), .string(), .time(), .time_tz(), .timestamp(), and .timestamp_tz(). And reviewing the docs[1], these are converted to a PostgreSQL native types, and not JSON types (additionally a bunch of those are not JSON types). Jeevan: can you please confirm that this work converts into the PostgreSQL native types?

OpenPGP_signature.asc
Description: OpenPGP digital signature