Re: jsonpath duplication result

2021-09-02 Thread Charles Paperman
Le 09/02 06:55, David G. Johnston a écrit : > On Thu, Sep 2, 2021 at 6:06 AM Charles Paperman > wrote: > > I also wonder if it is problematic to have simple small query like that > that can be design to make the database work endlessly? > > > > No, because the "simple small" part of th

Re: jsonpath duplication result

2021-09-02 Thread David G. Johnston
On Thu, Sep 2, 2021 at 6:06 AM Charles Paperman wrote: > I also wonder if it is problematic to have simple small query like that > that can be design to make the database work endlessly? > > No, because the "simple small" part of that doesn't matter. A user with access has various ways to affect

jsonpath duplication result

2021-09-02 Thread Charles Paperman
Hi, I am looking at the documentation and how jsonpath works and I fall on the following example: (On PostgreSQL 12.4, package for Debian 12.4-3): SELECT jsonb_path_query(j, '$.**.a.**.b') FROM (SELECT '{"a":{"a":{"b":{"c":3}}}'::jsonb as j) as T; The result: jsonb_path_query