Miss Dada  🏳️‍⚧️

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`

NaN being equal to itself in PG probably isn't a huge deal (though it is quite surprising). Not supporting NaN or Infinity at all seems more likely to cause issues, but even then it's still niche. But not implementing floating point types to spec seems like such a weird omission

it makes things kind of semantically weird to have identical non-null values which are nonequal, for instance, if NaN != NaN, should two rows both be able to have a NaN PK? i think the reasonable answer is no, but you now have two different notions of "equal"