Richard Heiser wrote: > Yeah - I've been looking around and I think you're > right. > > This is really quite astonishing - seems like a pretty > fundamental concept...
Not astonishing at all. SQL is a data access language, it was not intended to be computationally complete. I think this recursion feature was only added to the standard because people set up adjacency lists models quite often while they would be better served with nested tree models and then they need something to clean up the mess. Not because recursion fits in a relational model very well. But as I said, file a feature request for WITH RECURSIVE and use one of the available stored procedures for now. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
