Re: [GENERAL] tsearch2() with data from other table

[Teodor Sigaev]

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: [EMAIL PROTECTED]
                                                   WWW: http://www.sigaev.ru/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match