Revision 3750
Added by Jing Tao over 16 years ago
| 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
Some script to generate text search vector.