Btw, why do you want to create a new partial index which is already covered by a regular index? Do you want to remove that regular index after creating the partial one?
Something like that yes. The new index incorporates columns not covered by the existing index as well as a more restrictive conditional expression.
