tsearch2() with data from other table

Поиск
Список
Период
Сортировка
От Marcus Engene
Тема tsearch2() with data from other table
Дата
Msg-id 4554801A.9090108@engene.se
обсуждение исходный текст
Ответы Re: tsearch2() with data from other table  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-general
Hi,

I have a table with items.
One field is site_user, which fk:s the user row that owns the item.

There are a few fields i throw to tsearch2() via an index right now,
but one user wanted his name to be in the search as well. So, what I
would want to do is:

CREATE FUNCTION euits(int)
RETURNS text AS 'select username || \' \' || firstname || \' \' ||
lastname from site_user where objectid = $1;' LANGUAGE SQL;

CREATE TRIGGER site_item_fts
BEFORE UPDATE OR INSERT ON site_item
FOR EACH ROW EXECUTE PROCEDURE
tsearch2(idxfti, name, keywords, keywords_cb, location_country,
location_city, media_source, description, euits, site_user);

Pg accepts this, but when I

update site_item
set
     description = description

I get:
Query executed in 78 ms, 6 Row(s) Affected
WARNING:  TSearch: 'site_user' is not of character type
WARNING:  TSearch: 'site_user' is not of character type
...

I suppose I am doing something stupid here? If I remove euits
I still receive the same error.

Any suggestions are very welcome.

Best regards,
Marcus

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

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: Database Mirroring Solution
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: "stopping" a single database in a cluster