Using GIN indexes on 8.2

Поиск
Список
Период
Сортировка
От Alexander Staubo
Тема Using GIN indexes on 8.2
Дата
Msg-id 0EEBC3BD-DEEE-4924-96A0-D28093F1028E@purefiction.net
обсуждение исходный текст
Ответы Re: Using GIN indexes on 8.2  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-general
Two questions about GIN on 8.2. There's not much documentation about
GIN, but this should be possible:

   create table foo (values text[]);
   create index foo_values_index on foo using gin (text);

However, this then fails saying the operator "@" does not exist:

   select * from foo where values @ '{hello, world}'

Do I need to reference a specific opclass when creating the index?
 From the documentation I got the impression that GIN bundled
operators for most built-in types.

Secondly, are GIN indexes immutable and (unlike Tsearch2) non-lossy
and therefore useful with functional indexes? I would like to do this:

   create table bar (value text);
   create index bar_value_index on bar using gin (analyze(value));

where analyze() is a function of my own that tokenizes, stems and
filters the text into a text[] array.

Alexander.

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: AutoVacuum on demand?
Следующее
От: Marcus Engene
Дата:
Сообщение: Re: tsearch2() with data from other table