News for hackers. Stuff that matters.

A comment on Null Values in SQL Queries. Parent comment

Re:Null Values in SQL Queries by SigmundA on Monday February 03, 2020 @12:00PM (#22226082)
Normally can't use an index as every value has to be coalesced before comparison.
[ Parent | on HN ]
Re:Null Values in SQL Queries by danaliv on Monday February 03, 2020 @10:55PM (#22232236)
You can index the results of functions (or other expressions) in at least some databases. PostgreSQL can do this, for example.

  CREATE INDEX idx ON tbl (coalesce(col, ''))
Combining this with UNIQUE can make for some neat tricks.
[ Parent | on HN ]