--- 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.
__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com