Re: uppercase = lowercase

how do you mark it immutable?

2/14/2003 7:08:37 AM, Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com> 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.
>
>__________________________________________________
>Do you Yahoo!?
>Yahoo! Shopping - Send Flowers for Valentine's Day
>http://shopping.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>