3 ms·

I think if you try to force iterative ideas on this declarative language the result is frustration or fear But fortunately we have (tail) recursion to fight ba

I think if you try to force iterative ideas on this declarative language the result is frustration or fear But fortunately we have (tail) recursion to fight back in most declarative languages. Which is something that's completely missing from SQL. There should be a way to express recursion in SQL queries in my opinion.

yangyang 17y ago
Well Oracle has "connect by": http://www.oracle.com/technology/products/oracle9i/daily/oct04.html http://www.oracle.com/technology/products/oracle9i/daily/oct...
jamii 17y ago
Datalog is more or less equivalent to SQL with recursion. I don't know of any serious, database-backed implementations but there are a lot of in-memory implementations and some interesting extensions for distributed databases. http://en.wikipedia.org/wiki/Datalog http://en.wikipedia.org/wiki/Datalog