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`
-
Show this thread
-
Replying to @sgrif
Google BigQuery implements IEEE-754 for all finite values and all operations where at least one input is non-finite. Not sure the use case here but could be worth a try
2 replies 0 retweets 0 likes
Replying to @VNeilley
No use case. Curiosity of an orm maintainer
2:42 PM - 11 Jan 2020
0 replies
0 retweets
1 like
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.