Re: Best way to use indexes for partial match at

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Best way to use indexes for partial match at
Дата
Msg-id 1131636946.3554.62.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: Best way to use indexes for partial match at  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Best way to use indexes for partial match at  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Scott Frankel
Дата:
Сообщение: Re: build errors on MacOSX
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Where Statement