Re: tsearch2() with data from other table - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: tsearch2() with data from other table
Date
Msg-id 45548994.1050707@sigaev.ru
Whole thread Raw
In response to tsearch2() with data from other table  (Marcus Engene <mengpg@engene.se>)
Responses Re: tsearch2() with data from other table  (Marcus Engene <mengpg@engene.se>)
List 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);

site_user is a table, isn't it?
tsearch2 trigger accepts only column's names and functions with prototype TEXT
func(TEXT).

For clarify, show your table's definitions.
--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: "stopping" a single database in a cluster
Next
From: Martijn van Oosterhout
Date:
Subject: Re: ECPG and multiple threads