From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: A little confusion about JSON Path |
Date: | 2019-10-18 07:04:54 |
Message-ID: | ce47cf6f-6c1e-8172-88b5-31991fbf7dbc@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 ? (@.type() == "array")') -- returns false - not expected
>>
>> Apparently "@.type()" returns something different then "$.k1.list.type()"
>>
> This seems to be a consequence of "lax" mode:
>
> "Besides, comparison operators automatically unwrap their operands in the lax mode,
> so you can compare SQL/JSON arrays out-of-the-box. An array of size 1 is considered
> equal to its sole element. Automatic unwrapping is not performed only when:
>
> - The path expression contains type() or size() methods that return the type and
> the number of elements in the array, respectively.
>
> (from https://www.postgresql.org/docs/12/functions-json.html)
>
> with sample (data) as (
> values
> ('{"k1": {"list":[1,2,3]}}'::jsonb)
> )
> select data,
> jsonb_path_exists(data, '$.k1.list ? (@.type() == "number")'), -- lax mode unwraps the array
> jsonb_path_exists(data, 'strict $.k1.list ? (@.type() == "array")') -- strict mode doesn't
> from sample;
Ah, thanks. I did not see that part.
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2019-10-18 07:08:17 | Re: Postgres Point in time Recovery (PITR), |
Previous Message | Олег Самойлов | 2019-10-18 06:55:14 | Re: stable for each row before insert trigger |