Re: [HACKERS] SQL/JSON in PostgreSQL - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: [HACKERS] SQL/JSON in PostgreSQL
Date
Msg-id CAFj8pRChOWNezywNeZhe9xtN=pOKc1ANDxPAH13Jum-eDeXtzg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] SQL/JSON in PostgreSQL  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: [HACKERS] SQL/JSON in PostgreSQL
List pgsql-hackers
Hi

I am checking the JSONPath related code

Questions, notes:

1. jsonpath operators are not consistent with any other .. json, xml .. I am missing ?, @> operátors
2. documentation issue - there is "'{"a":[1,2,3,4,5]}'::json *? '$.a[*] ? (@ > 2)'" - operator *? doesn't exists
3. operator @~ looks like too aggressive shortcut - should be better commented

What is not clean, if jsonpath should to create some new operators for json, jsonb types? It is special filter, defined by type, so from my perspective the special operators are not necessary.

Regards

Pavel


pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: January CommitFest is underway!
Next
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Creating backup history files for backups taken from standbys