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