PLPerl Trigger to update text search

From: Alex Magnum <magnum11200(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: PLPerl Trigger to update text search
Date: 2015-07-31 12:07:44
Message-ID: CA+cR4zfEYDFbtFAwPFmXU34W7q+mMKJVKTT=1FQw0A=5-yG+sA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am trying to update a tsvector field through a plperl trigger.

$_TD->{new}{text_search} = to_tsvector('pg_catalog.english', 'text1 text2');

but plperl does not seem to like that...
ERROR: Undefined subroutine &main::to_tsvector called

anyone done that and could help me out if that is actually possible?

Thanks in advance
Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Kroon 2015-07-31 14:17:54 Re: conn = PQconnectdb(conninfo);
Previous Message mephysto 2015-07-31 11:25:00 Re: Backup fatal issue