From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Doc: improve documentation around jsonpath regular expressions. |
Date: | 2019-09-19 15:22:31 |
Message-ID: | E1iAyGN-0005M5-Je@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Doc: improve documentation around jsonpath regular expressions.
Provide some documentation about the differences between XQuery
regular expressions and those supported by Spencer's regex engine.
Since SQL now exposes XQuery regexps with the LIKE_REGEX operator,
I made this a standalone section designed to help somebody who
has to translate a LIKE_REGEX query to Postgres. (Eventually we might
extend Spencer's engine to allow precise implementation of XQuery,
but not today.)
Reference that in the jsonpath docs, provide definitions of the
XQuery flag letters, and add a description of the JavaScript-inspired
string literal syntax used within jsonpath. Also point out explicitly
that backslashes used within like_regex patterns will need to be doubled.
This also syncs the docs with the decision implemented in commit
d5b90cd64 to desupport XQuery's 'x' flag for now.
Jonathan Katz and Tom Lane
Discussion: https://postgr.es/m/CAPpHfdvDci4iqNF9fhRkTqhe-5_8HmzeLt56drH%2B_Rv2rNRqfg@mail.gmail.com
Branch
------
REL_12_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/b9cf94c8c2496af30dcdf7cea083463f6464dff0
Modified Files
--------------
doc/src/sgml/func.sgml | 213 ++++++++++++++++++++++++++++++++++++++++++++++++-
doc/src/sgml/json.sgml | 33 ++++++--
2 files changed, 235 insertions(+), 11 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Korotkov | 2019-09-19 19:11:07 | pgsql: Improve handling of NULLs in KNN-GiST and KNN-SP-GiST |
Previous Message | Peter Eisentraut | 2019-09-19 13:22:34 | pgsql: GSSAPI error message improvements |