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

Reply via email to