News for hackers. Stuff that matters.

A comment on Postgres 15 improves UNIQUE and NULL. Parent comment

Re:Postgres 15 improves UNIQUE and NULL by cwillu on Monday July 11, 2022 @07:12AM (#32054593)
Rather than putting the two types of meters in two different tables and doing an error-prone UNION, you would put the distortion measurements in a different table joined to the first, and the meters that don't support it would simply not include entries in that table.
[ Parent | on HN ]
Re:Postgres 15 improves UNIQUE and NULL by RedShift1 on Monday July 11, 2022 @07:36AM (#32054751)
But that would still get you nulls in the result set, which is what we're trying to avoid?
[ Parent | on HN ]