diff options
| author | Alexander Korotkov <akorotkov@postgresql.org> | 2021-05-13 16:10:21 +0300 |
|---|---|---|
| committer | Alexander Korotkov <akorotkov@postgresql.org> | 2021-05-13 16:10:21 +0300 |
| commit | 9b7286c2b394381c937559a98f35df64a92ffbac (patch) | |
| tree | fa6d50dfa7b8af1ba4e23049dabd92493617b69f /doc/src | |
| parent | a784859f4480ceaa05a00ca35311071ca33483d1 (diff) | |
| download | postgresql-9b7286c2b394381c937559a98f35df64a92ffbac.tar.gz postgresql-9b7286c2b394381c937559a98f35df64a92ffbac.zip | |
Improve documentation example for jsonpath like_regex operator
Make sample like_regex match string values of the root object instead of the
whole document. The corrected example seems to represent a more relevant
use case.
Backpatch to 12, when jsonpath was introduced.
Discussion: https://postgr.es/m/13440f8b-4c1f-5875-c8e3-f3f65606af2f%40xs4all.nl
Author: Erik Rijkers
Reviewed-by: Michael Paquier, Alexander Korotkov
Backpatch-through: 12
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 4d1f1794ca3..3a21129021a 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -17130,9 +17130,10 @@ $[*] ? (@ like_regex "^[aeiou]" flag "i") is a JSON path string literal, written according to the rules given in <xref linkend="datatype-jsonpath"/>. This means in particular that any backslashes you want to use in the regular expression must be doubled. - For example, to match strings that contain only digits: + For example, to match string values of the root document that contain + only digits: <programlisting> -$ ? (@ like_regex "^\\d+$") +$.* ? (@ like_regex "^\\d+$") </programlisting> </para> </sect3> |