devops/postgres/upgrade/0.0.4.sql

   1
   2 ALTER TABLE nodes
   3 DROP COLUMN IF EXISTS search_title,
   4 DROP COLUMN IF EXISTS tsvector;
   5
   6 ALTER TABLE nodes ADD COLUMN search_title tsvector;
   7 UPDATE nodes SET search_title = to_tsvector('english', coalesce("hyperdata"->>'title', '') || ' ' || coalesce("hyperdata"->>'abstract', ''));
   8 CREATE INDEX search_title_idx ON nodes USING GIN (search_title);
   9
  10
  11
  12