On Fri, Feb 22, 2008 at 11:14:41AM -0500, John Elrick wrote: > > IIUC ANSI SQL has a WITH keyword and support for recursive queries. > > > > SQLite doesn't support this, of course. But it could (whether it will > > is another story). > > A recursive trigger would handle this issue nicely...a way of SELECTing > a hierarchy would also be nice, but I believe there is nothing > standardized for that particular operation.
I'm not familiar with the specs, so I can't tell you for sure, but the results for my searches seem to indicate that WITH recursive queries are part of ANSI/ISO SQL. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users