On Fri, Feb 22, 2008 at 11:51:08AM -0500, Samuel Neff wrote: > I don't agree with the XML anaology. As I understand it, recursion in SQL > is referring to self-referencing tables that create a parent/child > relationship. This generally does not apply to XML since XML is > hierarchical but usually not recursive (i.e., the children are not the same > elements as the parents). Certainly it's possible and does happen, but for > the most part the relationship between XML elements can be easily mapped to > relational tables and does not require recursive SQL to process.
You've clearly not used xml2rfc. The schema for writing Internet-Drafts and RFCs in XML certainly does have recursive elements (e.g., the <t> and <list> elements). > Oracle has had recursive SQL support for a while and it's very helpful when > appropriately used. MSSQL adds hierarchical data types in 2008 to support > similar functionality. Yes. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
