3 ms·
While it's vendor-specific, SQL Server has a built-in solution for it: http://technet.microsoft.com/en-us/library/bb677173.aspx http://technet.microsoft.com/en-
by georgekronberg 9y ago
While it's vendor-specific, SQL Server has a built-in solution for it: http://technet.microsoft.com/en-us/library/bb677173.aspx http://technet.microsoft.com/en-us/library/bb677173.aspx
- z92 9y agoIt doesn't do what I supposed it would do. > A column of type hierarchyid does not automatically represent a tree. It is up to the application to generate and assign hierarchyid values in such a way that the desired relationship between rows is reflected in the values. Some applications might have a column of type hierarchyid that indicates the location in a hierarchy defined in another table.
- jimktrains2 9y agoPostgreSQL has ltree[0] which does the same thing, but that's not exactly what the OP is talking about. [0] https://www.postgresql.org/docs/current/static/ltree.html https://www.postgresql.org/docs/current/static/ltree.html