From: | Marcus Engene <mengpg(at)engene(dot)se> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | tsearch2() with data from other table |
Date: | 2006-11-10 13:35:22 |
Message-ID: | 4554801A.9090108@engene.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Browne | 2006-11-10 13:41:51 | Re: Database Mirroring Solution |
Previous Message | Adam Ciazynski | 2006-11-10 13:14:39 | Re: [GENERAL] ECPG and multiple threads |