Hi! On Mon, Sep 23, 2019 at 10:10 PM Steven Pousty <steve.pou...@gmail.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