Re: tsearch2() with data from other table

>>> 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);
<skip>
> So, when updating site_item I want to fetch the names from site_user and
> give this data to tsearch2() along with other stuff from site_item.

Sorry, current interface of tsvector aggregate doesn't support it.

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/