- or download this
CREATE TABLE sometable (
...
...
);
CREATE INDEX sometable_fulltext ON sometable
USING GIN (to_tsvector('english', keyword_search));
- or download this
keyword_search text not null GENERATED ALWAYS AS (
name || ' ' || COALESCE(description, '')
|| ' ' || COALESCE(tags, '')) STORED,
- or download this
SELECT * FROM sometable
WHERE to_tsvecor('english',keyword_search) @@ plainto_tsquery('english
+', ?)
ORSER BY ts_rank(to_tsvecor('english',keyword_search), plainto_tsquery
+('english', ?))