Fun read.
I've been tripped up by the where in partial indexes before. Same goes for expression indexes.
I've been tripped up by the where in partial indexes before. Same goes for expression indexes.
Hope this explanation helped explain why, at least a little bit.