Re: Hash index todo list item - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Hash index todo list item
Date
Msg-id 5977.1188866054@sss.pgh.pa.us
Whole thread Raw
In response to Re: Hash index todo list item  ("Ben Tilly" <btilly@gmail.com>)
Responses Re: Hash index todo list item
List pgsql-hackers
"Ben Tilly" <btilly@gmail.com> writes:
> That raises a very random thought.  One of the nicer features of
> Oracle is the ability to have function-based indexes.  So you could
> index, say, trim(lower(person.name)).

> Is there any prospect of postgres aquiring that functionality?

Uh, no, since it's already there; has been since Berkeley days ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: Hash index todo list item
Next
From: "Florian G. Pflug"
Date:
Subject: Re: Per-function GUC settings: trickier than it looked