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

From Ben Tilly
Subject Re: Hash index todo list item
Date
Msg-id acc274b30709031906j483ea2e9pe8fb6bcfd148c64e@mail.gmail.com
Whole thread Raw
In response to Re: Hash index todo list item  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 9/3/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "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 ...

Nice!

I know of at least one DBA who is moving from Oracle to postgres who
will be *very* happy to hear that.

Ben


pgsql-hackers by date:

Previous
From: "FAST PostgreSQL"
Date:
Subject: Updatable cursor doubt
Next
From: "Florian G. Pflug"
Date:
Subject: Re: Per-function GUC settings: trickier than it looked