From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
---|---|
To: | Marcus Engene <mengpg(at)engene(dot)se> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: tsearch2() with data from other table |
Date: | 2006-11-10 15:05:37 |
Message-ID: | 45549541.3010102@sigaev.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>>> 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/
From | Date | Subject | |
---|---|---|---|
Next Message | Teodor Sigaev | 2006-11-10 15:16:35 | Re: Using GIN indexes on 8.2 |
Previous Message | Jeremiasz Miedzinski | 2006-11-10 14:37:01 | Re: [PL/pgSQL] Commit every N rows. Is it possible ? |