On 12/9/15, jeremy at copiousfreetime.org wrote:
> So far it looks as if the way to distinguish between a json key existing
> with a
> value of null vs. not existing is to use `json_type`
>
> sqlite> select json_type('{"a":2,"c":[4,5,{"f":7}]}', '$.x') IS NULL;
> 1
> sqlite> select
On December 9, 2015 at 13:05:37 PM, Richard Hipp (drh at sqlite.org) wrote:
>?
> Also are there optimizations in place so that a column that is a json string?
> is only?
> parsed once if it is involved in json1 functions? For example:?
>?
No. The JSON parsing turned out to be so fast that such
Hi,
I?m experimenting with the json1 extension, and I?d like to confirm the proper
way to detect if a key exists in the json, vs its value being null. For example:
? sqlite> select json_extract('{"a":2,"c":[4,5,{"f":7}]}', '$.x');
? sqlite> select json_extract('{"a":2,"c":[4,5,{"f":7}]}',
3 matches
Mail list logo
