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@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
