Re: Tackling JsonPath support

On 29/11/16 07:37, Pavel Stehule wrote:
> 
> 
> 2016-11-29 7:34 GMT+01:00 Christian Convey <christian.convey@gmail.com
> <mailto:christian.convey@gmail.com>>:
> 
>     On Mon, Nov 28, 2016 at 9:28 PM, Pavel Stehule
>     <pavel.stehule@gmail.com <mailto:pavel.stehule@gmail.com>>wrote:
> 
>         We now support XPath function - JSONPath is similar to XPath -
>         it is better for user, because have to learn only one language.
> 
> 
>     I'm not sure I understand.
> 
>     Are you suggesting that we use XPath, not JSONPath, as our language
>     for json-path expressions?
> 
> 
> surely not.
> 
> follow ANSI/SQL :)
> 

Just to add to this, the SQL/JSON proposals I've seen so far, and what
Oracle, MSSQL and Teradata chose to implement already is basically
subset of jsonpath (some proposals/implementations also include
lax/strict prefix keyword on top of that). I think that should give us
some hint on what the base functionality should look like.

--  Petr Jelinek                  http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training &
Services