Re: tsearch2 in PostgreSQL 8.3?

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: tsearch2 in PostgreSQL 8.3?
Дата
Msg-id 87eji3v4s1.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: tsearch2 in PostgreSQL 8.3?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: tsearch2 in PostgreSQL 8.3?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> Yeah, unfortunately we overlooked the implications of the conversion to
> tsvector being environment-dependent.  Those opclasses will have to go
> away again.  AFAICS the only safe way to build an index directly on a
> text column is
>
> CREATE INDEX idxname ON tblname USING gin (to_tsvector('config', textcolumn));

Is there a null configuration which could be the default for the casts? So the
syntax would still work and would generate an index which worked well but has
no stop words, no stemming, etc?

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com


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

Предыдущее
От: Decibel!
Дата:
Сообщение: Re: Deferred Constraints
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: build farm failures