full_subdiagrams_transitive (view)
1 row where shape = "point" sorted by subshape
This data as json, CSV (advanced)
subshape ▼ | shape |
---|---|
empty diagram | point |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW "full_subdiagrams_transitive" AS with recursive t as ( select subshape, shape from full_subdiagrams union select full_subdiagrams.subshape, t.shape from full_subdiagrams join t where full_subdiagrams.shape == t.subshape ) select * from t;