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