Problem creating GIN index on multiple weighted columns

Поиск
Список
Период
Сортировка
От Ryan Fugger
Тема Problem creating GIN index on multiple weighted columns
Дата
Msg-id CAG8xytfGx9OHu4gg8-1onVpy6zV_4B1Am7Fh-x56uOeOCvfb_Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Problem creating GIN index on multiple weighted columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I'm using 8.4.8, attempting to run the following command:

=> create index profile_search_index on profile_profile using
gin(setweight(to_tsvector('english', name), 'A') ||
setweight(to_tsvector('english', description), 'B'));

I get this error:

ERROR:  syntax error at or near "||"
LINE 1: ... gin(setweight(to_tsvector('english', name), 'A') || setweig...
                                                             ^

Is this a bug, or a known limitation, or is my syntax just wrong?  The
following works fine:

select setweight(to_tsvector('english', name), 'A') ||
setweight(to_tsvector('english', description), 'B') from
profile_profile;

I would prefer not to store the precomputed tsvector in a separate
column if I can avoid it, although I'll do that if I can't get this to
work.  Thanks for any help.

Ryan

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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Pgadmin plugins
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Suspicious Bill