3 ms·
I think this is still workable with an expression/functional index, where the indexed expression is "happened_at IS NOT NULL".
by forkerenok 5y ago
I think this is still workable with an expression/functional index, where the indexed expression is "happened_at IS NOT NULL".
- isuckatcoding 5y agoSeems like a whole lot of extra trouble to be honest. What happens when you need to create a composite index?
- forkerenok 5y agoYou 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.