[sqlalchemy] Re: interval tree table

2009-03-18 Thread Michael Bayer

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

2009-03-18 Thread az

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
-~--~~~~--~~--~--~---