News for hackers. Stuff that matters.
Re:Postgres 15 improves UNIQUE and NULL by fendy3002 on Monday July 11, 2022 @07:39AM (#32054773)
Which happen in world of javascript. It has null and undefined. Null variable is a variable / property that's defined and set with null, while undefined is a variable / property that's not defined yet (or maybe not initialized, I forgot).

I hope at least SQL will give another comparison operation, such as the current equal sign (=) means a.prop is not null && b.prop is not null && a.prop equal b.prop (for not defined yet).

Let's say another sign like a.prop *= b.prop, meaning a.prop is null && b.prop is null || a.prop = b.prop (for our intention is both value are empty).

Re:Postgres 15 improves UNIQUE and NULL by pdw on Monday July 11, 2022 @08:09AM (#32055040)
Such a comparison operator exists: IS (NOT) DISTINCT FROM.