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