Re: JSONPATH documentation

Hi!

On Mon, Sep 23, 2019 at 10:10 PM Steven Pousty <steve(dot)pousty(at)gmail(dot)com> wrote:
> Thanks for the education on the path spec. Too bad it is in a zip doc - do you know of a place where it is publicly available so we can link to it? Perhaps there is some document or page you think would be a good reference read for people who want to understand more?
> https://standards.iso.org/ittf/PubliclyAvailableStandards/c067367_ISO_IEC_TR_19075-6_2017.zip

Yes, this link looks good to me. It's technical report, not standard
itself. So, it may have some little divergences. But it seems to be
the best free resource available, assuming standard itself isn't free.

> I am uncertain why JSONPath is considered part of the datatype any more so than string functions are considered part of the character datatype
> https://www.postgresql.org/docs/11/functions-string.html

Let me clarify my thoughts. SQL-level functions jsonb_path_*() (table
9.49) are clearly not part of jsonpath datatype. But jsonpath
accessors (table 8.25), functions (table 9.44) and operators (table
9.45) are used inside jsonpath value. So, technically they are parts
of jsonpath datatype.

P.S. We don't use top posting in mailing lists. Please, use bottom
posting. See https://en.wikipedia.org/wiki/Posting_style#Top-posting
for details.

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company