full_subdiagrams_transitive (view)
4 rows where shape = "tower" sorted by subshape
This data as json, CSV (advanced)
subshape ▼ | shape |
---|---|
arrow | tower |
empty diagram | tower |
pair of points | tower |
point | tower |
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;