Laurenz Albe schrieb am 17.10.2019 um 13:25:
>> I don't understand why the following two JSON Path expressions aren't doing
>> the same thing in Postgres 12:
>>
>> jsonb_path_exists(data, '$.k1.list.type() ? (@ == "array")'), -- returns
>> true as expected
>> jsonb_path_exists(data, '$.k1.list
Thomas Kellerer wrote:
> I don't understand why the following two JSON Path expressions aren't doing
> the same thing in Postgres 12:
>
> with sample (data) as (
> values
> ('{"k1": {"list":[1,2,3]}}'::jsonb)
> )
> select data,
>jsonb_path_exists(data, '$.k1
Hello,
I don't understand why the following two JSON Path expressions aren't doing the
same thing in Postgres 12:
with sample (data) as (
values
('{"k1": {"list":[1,2,3]}}'::jsonb)
)
select data,
jsonb_path_exists(data, '$.k1.list.type() ? (@ == "array")'),
