« Return to Thread: Hierarchical Deletion via a Trigger?

Re: Hierarchical Deletion via a Trigger?

by Nicolas Williams :: Rate this Message:

Reply to Author | View in Thread

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

 « Return to Thread: Hierarchical Deletion via a Trigger?