Re: Index order

Поиск
Список
Период
Сортировка
От Glyn Astill
Тема Re: Index order
Дата
Msg-id 503999.9859.qm@web25807.mail.ukl.yahoo.com
обсуждение исходный текст
Ответ на Re: Index order  (Oleg Bartunov <oleg@sai.msu.su>)
Ответы Re: Index order  (Korry Douglas <korry.douglas@enterprisedb.com>)
Список pgsql-general
>
> > Hi chaps,
> >
> > I was just wondering if there's any way to tweak
> the way an an index is ordered on a text field?
>
> Yes, it's called functional index. Write your function,
> which does
> whatever you want with your data and create index
> (foo(artist))
>

Hmm, I understand what you're saying, but how ion earth do I create a function that reorders the result based on all
thedifferent characters ^ . * etc that could cause this? 

Also does anyone know why this happens? Why is the caret ignored ibn the index order - surely that just plain wrong?






В списке pgsql-general по дате отправления:

Предыдущее
От: Glyn Astill
Дата:
Сообщение: Re: Obfuscated stored procedures (was Re: Oracle and Postgresql)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Index order