Re: PostgreSQL 17 Beta 1 release announcement draft

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
convertJSON 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
convertJSON values to other JSON data types.
 

The release note goes on to state:

==
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?

Thanks,

Jonathan

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