Metacat

CREATE TRIGGER tsvectorupdate BEFORE INSERT OR UPDATE ON xml_path_index FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger(nodedatavector, 'pg_catalog.english', nodedata);

BEGIN;

ALTER TABLE xml_nodes  ADD COLUMN nodedatavector TSVECTOR;

UPDATE xml_nodes SET  nodedatavector = to_tsvector(nodedata);

CREATE TRIGGER xml_node_tsvectorupdate BEFORE INSERT OR UPDATE ON xml_nodes FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger(nodedatavector, 'pg_catalog.english', nodedata);

CREATE INDEX xml_node_vector ON xml_nodes USING gin(nodedatavector);

COMMIT;