Function tsearch2

A trigger function that that sets a text search vector based on the supplied text.

tsearch2(tsv TSVECTOR, txt TEXT [, txt TEXT ...]) RETURNS TRIGGER

CREATE TRIGGER ts_vec_update 
BEFORE INSERT OR UPDATE ON postgresql_manual 
FOR EACH ROW EXECUTE PROCEDURE tsearch2('ts_vec', 'body');

CREATE TRIGGER

DROP TRIGGER ts_vec_update ON postgresql_manual;

DROP TRIGGER

CREATE TRIGGER ts_vec_update 
BEFORE INSERT OR UPDATE ON postgresql_manual 
FOR EACH ROW EXECUTE PROCEDURE tsearch2('ts_vec', 'title', 'body');

CREATE TRIGGER