Metacat

BEGIN;

ALTER TABLE xml_path_index  ADD COLUMN nodedatavector TSVECTOR;

UPDATE xml_path_index SET  nodedatavector = to_tsvector(nodedata);

tsvector_update_trigger(nodedatavector, 'pg_catalog.english', nodedata);

CREATE INDEX xml_path_index_vector ON xml_path_index USING gin(nodedatavector);

COMMIT;