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

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

Previous
From: Michael Fuhr
Date:
Subject: Re: Where Statement
Next
From: Peter Eisentraut
Date:
Subject: Re: Best way to use indexes for partial match at