Re:My Opinion on “5” == 5
by em500 on Thursday July 29, 2021 @01:49PM
(#27999266)
> I agree with the premise - SQL gets it right, but perhaps only in PostgreSQL?
I don't agree with the premise. Both MySQL[1] and MS SQL Server [2] do an implicit cast and then compare them as numbers. I don't know whether this is ANSI standard behavior though.
I don't agree with the premise. Both MySQL[1] and MS SQL Server [2] do an implicit cast and then compare them as numbers. I don't know whether this is ANSI standard behavior though.
[1] https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
[2] https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-t...