Re: tsearch2 in PostgreSQL 8.3?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: tsearch2 in PostgreSQL 8.3?
Дата
Msg-id 200708171606.15909.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: tsearch2 in PostgreSQL 8.3?  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: tsearch2 in PostgreSQL 8.3?
Re: tsearch2 in PostgreSQL 8.3?
Re: tsearch2 in PostgreSQL 8.3?f
Список pgsql-hackers
Bruce,

> Oh, so you want the config inside each tsvector value.  Interesting
> idea.

Yeah, hasn't anyone suggested this before?  It seems like the obvious
solution.  A TSvector constructed with en_US is NOT the same as a vector
constructed with fr_FR and it's silly to pretend that they are comparable.
Sticking the config name at the beginning of the field would allow for the
use of single-parameter functions, and default_config would only be used
for SELECT queries.  Backup/restore issues should go away completely ...

EXCEPT this would introduce issues if the config is changed or deleted
after being used.  However, I'd imagine that we have those anyway --
certainly we would at restore time.

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco


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

Предыдущее
От: Ron Mayer
Дата:
Сообщение: Re: tsearch2 in PostgreSQL 8.3?
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: tsearch2 in PostgreSQL 8.3?