0.0.4.sql

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);