2 ms·
SQL is mostly functional - it’s had some adoption. A Function is just a: m-1 or 1-1 Relation - with a guarantee that same input always gets the same output. It
by garyclarke27 8y ago
SQL is mostly functional - it’s had some adoption.
A Function is just a: m-1 or 1-1 Relation - with a guarantee that same input always gets the same output.
It’s quite easy to setup Postgres to behave this way (it was originally designed as immutable with time travel) ie never delete anything, then use bi-temporal logic to retract records previously asserted as fact.
- tannhaeuser 8y agoI'd say SQL is closer to logic programming with its use of tuple variables, and generally being about specifying what you want to select rather than how. You could also say it's closer to algebra (relational "algebra", that is).