On Tue, Dec 31, 2013 at 8:59 PM, James K. Lowden <jklow...@schemamania.org>wrote:
> Recursive queries are a unique feature of CTEs. They are not supported > in SQLite. If and when they are, CTEs will be required. > Not necessarily. Oracle has had the START WITH CONNECT BY syntax for recursive queries since the eighties: http://docs.oracle.com/cd/B28359_01/server.111/b28286/queries003.htm#SQLRF52315 I think I prefer that over recursive CTES if implementing recursive queries is the only goal. On the other hand CTEs _are_ part of the SQL:1999 standard and Oracle also supports them. --Constantine _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users