News for hackers. Stuff that matters.

A comment on You might as well timestamp it. Parent comment

Re:You might as well timestamp it by forkerenok on Saturday April 24, 2021 @06:46AM (#26923895)
I think this is still workable with an expression/functional index, where the indexed expression is "happened_at IS NOT NULL".
[ Parent | on HN ]
Re:You might as well timestamp it by isuckatcoding on Saturday April 24, 2021 @07:47AM (#26924216)
Seems like a whole lot of extra trouble to be honest. What happens when you need to create a composite index?
[ Parent | on HN ]
Re:You might as well timestamp it by forkerenok on Saturday April 24, 2021 @07:55AM (#26924247)
You can do indexes that are composites of plain field values and/or expressions! At least in Postgres.

As for the trouble, I agree, it's a bit more involved.

[ Parent | on HN ]