10 lines
304 B
Plaintext
10 lines
304 B
Plaintext
# j is a JSON object ; return a list of the keys for which the value is less than 1
|
|
create or replace function report(j) as (
|
|
list_filter(json_keys(j), k -> (j -> k) < 1 )
|
|
);
|
|
|
|
select count(*) from
|
|
from (select report(struct_pack(*COLUMNS('flag'))::JSON) as flags
|
|
from t
|
|
where flags = []);
|