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