0.0.4.sql 351 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12

ALTER TABLE nodes
DROP COLUMN IF EXISTS search_title,
DROP COLUMN IF EXISTS tsvector;

ALTER TABLE nodes ADD COLUMN search_title tsvector;
UPDATE nodes SET search_title = to_tsvector('english', coalesce("hyperdata"->>'title', '') || ' ' || coalesce("hyperdata"->>'abstract', ''));
CREATE INDEX search_title_idx ON nodes USING GIN (search_title);