On Fri, Nov 22, 2013 at 10:34 PM, Strahinja Kustudić <strahinjak(at)nordeus(dot)com
> wrote:
> Nice question, I would also like to know this.
>
> 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.