From: Wei Weng <wweng@kencast.com>
To: pgsql-sql@postgresql.org
Subject: suggestion needed for implementation
Date: Mon, 6 Oct 2003 12:29:31 -0400 (EDT)
Message-ID: <Pine.LNX.4.56.0310061207070.3133@localhost.localdomain> (raw)
I need to create triggers on a number of tables that have full text search
capability. The trigger, basically, needs to call select
set_curcfg('default') first to set the locale , then call tsearch2
function on the text columns in the table to update the index. How can I
implement a trigger that does two different thing (select and tsearch2)
together? I was thinking about making them into one function, say,
function updatetbl(), that does two things together. But then, postgresql
does not allow variable length of arguments. updatetbl can not just take
arbitrary number of arguments to pass on tsearch2.
What can I do here to implement this trigger?
Thanks
Wei
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: wweng@kencast.com
Subject: Re: suggestion needed for implementation
In-Reply-To: <Pine.LNX.4.56.0310061207070.3133@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox