| From: | "Ben Tilly" <btilly(at)gmail(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Gregory Stark" <stark(at)enterprisedb(dot)com>, "Kenneth Marshall" <ktm(at)rice(dot)edu>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Hash index todo list item |
| Date: | 2007-09-04 02:06:35 |
| Message-ID: | acc274b30709031906j483ea2e9pe8fb6bcfd148c64e@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 9/3/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Ben Tilly" <btilly(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Florian G. Pflug | 2007-09-04 02:41:58 | Re: Per-function GUC settings: trickier than it looked |
| Previous Message | FAST PostgreSQL | 2007-09-04 01:44:15 | Updatable cursor doubt |