Re: Best way to use indexes for partial match at

On Thu, 2005-11-10 at 07:45, Peter Eisentraut wrote:
> Am Donnerstag, 10. November 2005 10:19 schrieb Andrus:
> > thank you. I don't understand how to delete primary key index without
> > removing primary key constraint or how to force primary key to use foo_bar
> > index.
>
> You cannot drop the primary key index without dropping the primary key, and
> you cannot change the primary key to use a different index.

Ya know, this brings up an interesting question, would it be feasible to
allow for a function of somekind to be applied as an argument to a
primary key declaration?  It would certainly be useful for character
type pks in non-C locales.