Hacker News new | ask | show | jobs
by Recursing 521 days ago
Surprised that this doesn't mention "IS DISTINCT FROM" ( https://modern-sql.com/caniuse/is-distinct-from )

(Although in rare cases that is even weirder: https://stackoverflow.com/a/58998043 )

1 comments

I'm glad SQL Server finally got this, but I wish the syntax was nicer. It's a multi-word infix operator that gets tough to read. I've been using Snowflake SQL recently and I like that they just made it a function called EQUAL_NULL