Re: JSONpath query that returns paths to the matches - Mailing list pgsql-novice

From David G. Johnston
Subject Re: JSONpath query that returns paths to the matches
Date
Msg-id CAKFQuwYVhCVwa0qfTfpvkziLnj_ogdpGruJhFqJ=Zig=n2+LuA@mail.gmail.com
Whole thread Raw
In response to JSONpath query that returns paths to the matches  (Alex R <ralienpp@gmail.com>)
Responses Re: JSONpath query that returns paths to the matches
List pgsql-novice
On Thu, Dec 16, 2021 at 8:57 AM Alex R <ralienpp@gmail.com> wrote:
It returns 2 matches: "aaa" and "bbb". However, what I'd like to get instead is 2 paths that point to the matches, i.e.,:
- $.that[0]
- $.nested.deep

Can this be accomplished using means that are available out of the box? If not, what would be a sane way of implementing it?

1. Not that I can see documented.

2a See if some other language that has a PL extension for PostgreSQL can do this more easily and write a function in the language.
2b Create a custom C language function based off of one of the existing "path exists" functions that keeps track of its position in the graph and the returns that instead of a boolean/whatever.
2c Create your own procedural code, which can be done in pl/pgsql, that performs the graph traversal and captures the data like in 2b.

David J.

pgsql-novice by date:

Previous
From: Alex R
Date:
Subject: JSONpath query that returns paths to the matches
Next
From: Alex R
Date:
Subject: Re: JSONpath query that returns paths to the matches