[sqlalchemy] Re: interval tree table
bard stéphane wrote: > > is there an easy way to represent an interval tree table in sqlAlchemy > Interval Tree is very common way to represent tree. > with right, left, level indices, node, leaf (left - right = 1) ? there's no restriction using the SQL expression language. The ORM can do it too, see the example examples/nested_sets/nested_sets.py in the tar.gz distribution for a recipe. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: interval tree table
On Wednesday 18 March 2009 22:31:37 bard stéphane wrote: > is there an easy way to represent an interval tree table in > sqlAlchemy Interval Tree is very common way to represent tree. > with right, left, level indices, node, leaf (left - right = 1) ? FIY see this thread with various tree rerpesentations (my or may not be there): Adjacency List tree - inefficient reading From: Kless To: sqlalchemy Date: 2009-01-18 20:33 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---