path: root/web/panettone/src/migrations/3920286378-add-issue-tsv.lisp



"Add tsvector for full-text search of issues"

(defun up ()
  (query "ALTER TABLE issues ADD COLUMN tsv tsvector GENERATED ALWAYS AS (to_tsvector('english', subject || ' ' || body)) STORED")
  (query "CREATE INDEX issues_tsv_index ON issues USING GIN (tsv);"))
"Add tsvector for full-text search of issues"

(defun up ()
  (query "ALTER TABLE issues ADD COLUMN tsv tsvector GENERATED ALWAYS AS (to_tsvector('english', subject || ' ' || body)) STORED")
  (query "CREATE INDEX issues_tsv_index ON issues USING GIN (tsv);"))