Re: uppercase = lowercase
От | Dennis Gearon |
---|---|
Тема | Re: uppercase = lowercase |
Дата | |
Msg-id | B697YTLFWRJE5ONUD8C78321PC7RO.3e4d2a8a@cal-lab обсуждение исходный текст |
Ответ на | Re: uppercase = lowercase (Jeff Eckermann <jeff_eckermann@yahoo.com>) |
Ответы |
Re: uppercase = lowercase
|
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: