Re: Best way to use indexes for partial match at - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Best way to use indexes for partial match at
Date
Msg-id 1131636946.3554.62.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Best way to use indexes for partial match at  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Best way to use indexes for partial match at
List pgsql-general
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.

pgsql-general by date:

Previous
From: Scott Frankel
Date:
Subject: Re: build errors on MacOSX
Next
From: Michael Fuhr
Date:
Subject: Re: Where Statement