Does any SQL database actually implement IEEE 754 for floats? MySQL can't represent NaN or Infinity, SQLite can't represent NaN (and has no way to specify Infinity as a literal, but will coerce 9e999), and PG returns true for `'NaN'::float = 'NaN'::float`
-
-
it wouldn't be sql if we weren't making bizarre tradeoffs!
-
I'd love to be horrified by someone who has an actual production table using a float PK (my bet is that the PK is used for ordering or something and they used a float so they can re-order without changing other records PKs)
End of conversation
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.