suggestion needed for implementation

From: Wei Weng <wweng(at)kencast(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: suggestion needed for implementation
Date: 2003-10-06 16:29:31
Message-ID: Pine.LNX.4.56.0310061207070.3133@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Faulkner 2003-10-06 16:35:11 create new field
Previous Message Louise Cofield 2003-10-06 16:26:59 Multiple table join