Hello, Couldn’t help but notice a brand new branch in SQLite’s repository, the one labeled "Start a new experimental branch for support of Oracle-style CONNECT BY syntax.”.
http://www.sqlite.org/src/info/4365ddd62d Two reactions: (1) Recursive queries! Yes! Hurray! :D (2) CONNECT BY syntax?!? What the…!!! To paraphrase Ridley Scott: “On the interweb, no one can hear you scream.” If you are considering a syntax for recursion... please, please, pretty please, use Common Table Expression. Even Oracle does use it now. "Common table expressions are supported by DB2, Firebird, Microsoft SQL Server, Oracle (with recursion since 11g release 2), PostgreSQL (since 8.4), HyperSQL and H2 (experimental).”. http://en.wikipedia.org/wiki/Hierarchical_and_recursive_queries_in_SQL Let have SQLite added to that list :)) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users