On Fri, Feb 22, 2008 at 09:24:06AM -0700, Dennis Cote wrote: > As Nicolas said, SQL:1999 defines a standard method of doing this. It > uses a WITH RECURSIVE clause as a prefix to a SELECT. It hasn't been > widely implemented, but I believe that IBM's DB2 supports this mechanism.
Ah, good to know. Would there be interest in supporting that in SQLite? I think it'd be very useful (particularly given the populatiry of XML). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
