6 lines
233 B
Text
6 lines
233 B
Text
with allflags as (
|
|
select array_agg(flags) as flags
|
|
from (select report(struct_pack(*COLUMNS('flag'))::JSON) as flags from t)
|
|
)
|
|
select list_reduce( flags, (acc,x) -> list_intersect(acc,x) ) as "never worked"
|
|
from allflags;
|