Re: Indexes

Поиск
Список
Период
Сортировка
От will trillich
Тема Re: Indexes
Дата
Msg-id 20010904212142.B8460@serensoft.com
обсуждение исходный текст
Ответ на Indexes  ("Stan" <stan@mec.law.univ.szczecin.pl>)
Список pgsql-general
On Wed, Aug 29, 2001 at 10:44:56AM +0200, Stan wrote:
> How can I change the sequence of characters in PostgreSQL character indexes

create index some_ix
    on some_tbl ( substr(some_fld,3,1) || substr(some_other_fld,12,5) );

but if you look hard enough, you'll usually find a better model
by restructuring your data.

--
Hey, let's change the whole justice system. Everybody gets to
kill one person -- if you do two, you go to jail. That should
cut down on the abrasive personalities, don't you think?

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: jdbc driver with BigDecimal patch
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Bug in createlang?