Re: pgsql: SQL/JSON query functions

2022-04-02 Thread Andrew Dunstan
On 4/2/22 01:20, Tom Lane wrote: > Michael Paquier writes: >> On Tue, Mar 29, 2022 at 08:57:37PM +, Andrew Dunstan wrote: >>> SQL/JSON query functions >> Some of the tests introduced in this commit are a bit unstable when >> run through a primary/standby setup. > Yeah, looks like some of the

Re: pgsql: SQL/JSON query functions

2022-04-01 Thread Tom Lane
Michael Paquier writes: > On Tue, Mar 29, 2022 at 08:57:37PM +, Andrew Dunstan wrote: >> SQL/JSON query functions > Some of the tests introduced in this commit are a bit unstable when > run through a primary/standby setup. Yeah, looks like some of these queries need an ORDER BY.

Re: pgsql: SQL/JSON query functions

2022-04-01 Thread Michael Paquier
Hi Andrew, On Tue, Mar 29, 2022 at 08:57:37PM +, Andrew Dunstan wrote: > SQL/JSON query functions > > This introduces the SQL/JSON functions for querying JSON data using > jsonpath expressions. The functions are: > > JSON_EXISTS() > JSON_QUERY() > JSON_VALUE() > > All of these functions onl

pgsql: SQL/JSON query functions

2022-03-29 Thread Andrew Dunstan
SQL/JSON query functions This introduces the SQL/JSON functions for querying JSON data using jsonpath expressions. The functions are: JSON_EXISTS() JSON_QUERY() JSON_VALUE() All of these functions only operate on jsonb. The workaround for now is to cast the argument to jsonb. JSON_EXISTS() test