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