4 ms·
Isn't SQL a functional language, of sorts? http://stackoverflow.com/questions/1153397/besides-a-declarative-language-is-sql-a-functional-language http://stacko
by kristianp 15y ago
Isn't SQL a functional language, of sorts? http://stackoverflow.com/questions/1153397/besides-a-declarative-language-is-sql-a-functional-language http://stackoverflow.com/questions/1153397/besides-a-declara...
- sp332 15y agoThe answers on that page say "no".
- Dn_Ab 15y agoIt is a declarative language. But the underlying math of SQL is that of relations. It's closer to prolog than to Haskell. I don't know much about the theory of SQL but at least I can draw on the analogy of deriving algorithms in a Relational setting vs a functional to emphasize that the essence of functions is not the same as the essence of relations: Unlike functions, relations can be nondeterministic and each relation has a converse.
- gaius 15y agoIn PL/SQL a "function" in the FP sense would be called "deterministic".