[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] PLPerl Trigger to update text search
From:       Alex Magnum <magnum11200 () gmail ! com>
Date:       2015-07-31 12:19:44
Message-ID: CA+cR4zfEYDFbtFAwPFmXU34W7q+mMKJVKTT=1FQw0A=5-yG+sA () mail ! gmail ! com
[Download RAW message or body]

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

[Attachment #3 (text/html)]

<div dir="ltr">Hi,<div><br></div><div>I am trying to update a tsvector field through \
a plperl trigger.</div><div><br></div><div>$_TD-&gt;{new}{text_search} = \
to_tsvector(&#39;pg_catalog.english&#39;, &#39;text1 \
text2&#39;);<br></div><div><br></div><div>but plperl does not seem to like that...  \
<br>ERROR:   Undefined subroutine &amp;main::to_tsvector called  \
<br></div><div><br></div><div>anyone done that and could help me out if that is \
actually possible?</div><div><br></div><div>Thanks in \
advance</div><div>Alex</div></div>



[prev in list] [next in list] [prev in thread] [next in thread]