Re: [GENERAL] PLPerl Trigger to update text search

[Alex Hunsaker]

On Fri, Jul 31, 2015 at 7:15 PM, Alex Hunsaker <bada...@gmail.com> wrote:

>
>
>
> $_TD->{new}{text_search} =
> spi_exec_query("to_tsvector('pg_catalog.english', ". quote_literal('text1
> text2') .";")->{rows}[0]{to_tsvector};
>
>
Err that should be:
(still untested, was missing the "select" bit)

$_TD->{new}{text_search} = spi_exec_query("select
to_tsvector('pg_catalog.english', ". quote_literal('text1 text2')
.";")->{rows}[0]{to_tsvector};