schema_version_20.sql 221 B

123
  1. alter table entries add column document_vectors tsvector;
  2. update entries set document_vectors = to_tsvector(title || ' ' || coalesce(content, ''));
  3. create index document_vectors_idx on entries using gin(document_vectors);