Re: uppercase = lowercase

--- 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.

__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com