Re: uppercase = lowercase

how do you mark it immutable?

2/14/2003 7:08:37 AM, Jeff Eckermann <jeff_eckermann@yahoo.com> 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.
>
>__________________________________________________
>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@postgresql.org
>