Y
Hacker News
new
|
ask
|
show
|
jobs
by
forkerenok
1889 days ago
I think this is still workable with an expression/functional index, where the indexed expression is "happened_at IS NOT NULL".
1 comments
isuckatcoding
1889 days ago
Seems like a whole lot of extra trouble to be honest. What happens when you need to create a composite index?
link
forkerenok
1888 days ago
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.
link