Top "Transitive-closure-table" questions

MySQL Closure Table hierarchical database - How to pull information out in the correct order

I have a MySQL database holding hierarchical data using the Closure Table method. A simple sample database create script follows …

mysql hierarchical-data transitive-closure-table

Recursive query used for transitive closure

I've created a simple example to illustrate transitive closure using recursive queries in PostgreSQL. However, something is off with my …

sql postgresql common-table-expression recursive-query transitive-closure-table

Hierarchical SQL data (Recursive CTE vs HierarchyID vs closure table)

I have a set of hierarchical data being used in a SQL Server database. The data is stored with a …

sql-server common-table-expression recursive-query hierarchyid transitive-closure-table

Recursive query challenge - simple parent/child example

Note: with help from RhodiumToad on #postgresql, I've arrived at a solution, which I posted as answer. If anyone can …

sql postgresql recursive-query transitive-closure-table