On Mar 19, 12:55 pm, Michael Lang <[email protected]> wrote: > I don't know if it makes any difference, but I actually first attempt at > using the recursive select stuff to build my tree plugin in the > "sequel_plus" gem, but found right off the bat that not all DBMS supports > such fancy syntax, so I fell back to a safer implementation. > > Also, I started reading that linked article, but didn't get too far into it > before getting distracted by real work and deadlines, so we may be talking > about two different things with regards to trees and adjacency plugins... > > Michael
Nope, it's the same thing. The plugin probably only works on PostgreSQL 8.4+, MSSQL 2005+, and maybe a recent version of Firebird. Recursive common table expressions are in a recent SQL standard, but not many databases support them yet. Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
