Re: Best way to use indexes for partial match at

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

You would have to guarantee somehow that the function is a one-to-one
mapping, in order not to destroy the integrity of the primary key
constraint.  I cannot think of any useful functions that fulfill this
criterion.

> It would certainly be useful for character
> type pks in non-C locales.

I don't see how.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Where Statement
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Best way to use indexes for partial match at