Nicolas Williams wrote:
> 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).
I could be mistaken, however, I believe that recursive triggers or
recursive selects would be highly useful as a substitute for enforcing
referential integrity, especially cascading deletes.
John
_______________________________________________
sqlite-users mailing list
sqlite-users@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
