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.
I've been tripped up by the where in partial indexes before. Same goes for expression indexes.