2 ms·
SQL is statically type-checked, at least in Postgres. postgres=# SELECT * FROM domains WHERE id = 'foo'; ERROR: invalid input syntax for integer: "foo"
by majewsky 9y ago
SQL is statically type-checked, at least in Postgres.
postgres=# SELECT * FROM domains WHERE id = 'foo';
ERROR: invalid input syntax for integer: "foo"
LINE 1: SELECT * FROM domains WHERE id = 'foo';
^
- cpfohl 9y agoNot just PostGres. That's standard SQL. Columns have data types. Tables have schemata. Schemata are very strongly typed. Can't insert a 'full_name' column into a table without such a column.