On Sun, 9 Nov 2008 20:39:23 +0100, "Sébastien Roux" <[EMAIL PROTECTED]> wrote in General Discussion of SQLite Database <sqlite-users@sqlite.org>:
>Hi, > >Is there a way of doing hierarchical queries with SQLite. I'm not a killer >with SQL language but I've seen that there are some hierarchical functions >under Oracle. >I'm having a hierarchy stored as a parent/child relationship. SQLite doesn't support recursive statements. Perhaps you can convert the structure to a nested set model, so you can avoid recursion. http://www.dbazine.com/oracle/or-articles/tropashko4 http://www.developersdex.com/gurus/articles/112.asp >Thanks for your help. > >Sébastien Roux -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
