| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> |
| Cc: | Ken Guest <kguest(at)stockbyte(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: uppercase = lowercase |
| Date: | 2003-02-14 15:33:40 |
| Message-ID: | 20030214073129.F62399-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 14 Feb 2003, Jeff Eckermann wrote:
> --- Oliver Elphick <olly(at)lfix(dot)co(dot)uk> wrote:
> > On Fri, 2003-02-14 at 11:20, Ken Guest wrote:
> > > Is it truly possible to create an index on lets
> > say upper(last_name)?
> >
> > CREATE INDEX uppername_index ON mytable
> > (upper(last_name));
> >
> Unless something has changed, I believe that the
> "upper" statement would need to be wrapped in a
> function marked "immutable". Otherwise the index
> would not be used.
Upper should be immutable already.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-02-14 15:35:23 | Re: Postgres Databases growing without much reason |
| Previous Message | Ken Guest | 2003-02-14 15:14:19 | natural sort order |