3 ms·
No it is strongly typed, there is no accident that all PL extensions to the base query language have such a Ada/Pascal similarity. Additional DML has plenty of
by pjmlp 2mo ago
No it is strongly typed, there is no accident that all PL extensions to the base query language have such a Ada/Pascal similarity.
Additional DML has plenty of options to enforce rules that keep data consistency.
While they make the life harder to delete/update/insert items in specific sequences, they can save the day on bad queries.
- bazoom42 2mo agoWhat happens if a query compares a string to a number?
- mike_hearn 2mo agoYou get a type error from the database.
- bazoom42 2mo agoAs far as I can tell, some engines will implicitly coerce types so “7” = 7
- moljac024 2mo agoBut when do you get that type error? This is the important bit. You get it after the app is deployed, the query is ran and a result is expected. When do I get a type error from my language if it's statically typed? That's right, before I even deploy.