Re: JSON doc example (matchiness)
Alexander Korotkov <aekorotkov@gmail.com>
From: Alexander Korotkov <aekorotkov@gmail.com>
To: Erik Rijkers <er@xs4all.nl>
Cc: Michael Paquier <michael@paquier.xyz>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-05-09T01:01:47Z
Lists: pgsql-hackers
Attachments
- doc_jsonpath_like_regex_example.patch (application/octet-stream) patch
On Sat, May 8, 2021 at 7:09 PM Erik Rijkers <er@xs4all.nl> wrote: > On 5/8/21 3:48 AM, Michael Paquier wrote: > > On Fri, May 07, 2021 at 10:18:44PM +0200, Erik Rijkers wrote: > >> The JSON doc has this example (to show the need for double backslash): > >> > >> $ ? (@ like_regex "^\\d+$") > >> > >> > >> The example is not wrong exactly, and can be cast to jsonpath, but as-is can > >> never match anything. > >> > >> I think it'd be helpful to provide that example so that it more probably > >> matches when the user does a quick trial. > >> > >> Llet's change it to something like: > >> > >> $.* ? (@ like_regex "^\\d+$") > > Ah, I see. What you are telling here is that we match the regex on > > the full JSON string, which is pretty useless, and you are suggesting > > to change things so as we'd match with the key names at the first > > level. Makes sense. > > > > This paragraph of the docs say: > > "For example, to match strings that contain only digits" > > Could we be more precise here? "strings" looks to much generic to > > me in this context when actually referring to a set of path of keys in > > a JSON blob. > > Yes, "string values" is probably another small improvement. What about the attached patch? Wording "string values of the root object" seems most precise to me. ------ Regards, Alexander Korotkov
Commits
-
Improve documentation example for jsonpath like_regex operator
- f0d20e5973a2 12.8 landed
- ff91d3a22b9a 13.4 landed
- 9b7286c2b394 14.0 landed