Re: PLPerl Trigger to update text search

[Alex Hunsaker <badalex@xxxxxxxxx>]

On Fri, Jul 31, 2015 at 7:15 PM, Alex Hunsaker <badalex@xxxxxxxxx> 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};