On Fri, 14 Feb 2003, Jeff Eckermann wrote:
> --- Oliver Elphick <olly@lfix.co.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.