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