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
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
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