postgres.git / summary / log / commit / refs

commit    f0d20e5973a26207c0e8efbb09e0b1cf7c27cc64
Author:   Alexander Korotkov <akorotkov@postgresql.org>
Date:     Thu May 13 13:10:21 2021 +0000
First released in: 14.0, 12.8, 13.4

    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


doc/src/sgml/func.sgml | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index bdc2ab54845..038744a27fc 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -13238,9 +13238,10 @@ strict $.**.HR 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> [parent: 6e9723cde5c6]