Project

General

Profile

Revision 3750

Added by Jing Tao about 13 years ago

Some script to generate text search vector.

View differences:

src/tsvector.sql
1
BEGIN;
2
ALTER TABLE xml_path_index  ADD COLUMN nodedatavector TSVECTOR;
3
UPDATE xml_path_index SET  nodedatavector = to_tsvector(nodedata);
4
tsvector_update_trigger(nodedatavector, 'pg_catalog.english', nodedata);
5
CREATE INDEX xml_path_index_vector ON xml_path_index USING gin(nodedatavector);
6
COMMIT;
0 7

  

Also available in: Unified diff