4 ms·
There are calculated columns in SQL, which means there's no formula/value separation there either. Therefore also spreadsheets do offer "views": all the cells
by LogicUpgrade 6y ago
There are calculated columns in SQL, which means there's no formula/value separation there either.
Therefore also spreadsheets do offer "views": all the cells are formulas.
Regarding "shit typed", so is SQLite, but it works well.
- PaulHoule 6y agoSQL dbs vary. You can write select a from b where 1 in MySQL and Oracle, because those db's treat true and false as 1 and 0, you can write select sum(a=1), sum(a=2) from b others like microsoft sql and postgresql enforce a separate boolean type which means you have to put the ternary operator into the sum.
- wruza 6y agoBy shit typed I meant entering or pasting 1.200 into a numeric field and getting -600,000 something. This is exclusive to excel, which is “smart” enough to detect patterns in input, but not smart enough to introduce/look at the cell affinity, at locale settings or at common sense.