plainto_or_tsquery

CREATE OR REPLACE FUNCTION plainto_or_tsquery (TEXT) RETURNS tsquery AS $$
SELECT to_tsquery (regexp_replace ($1, E ' [\\s \' | :& ()!] + ', ' | ', ' g '));
$$ LANGUAGE SQL STRICT IMMUTABLE;

source: http://www.progtown.com/topic700061-selection-of-keywords-to-the-text.html

tsvector update table dan create index

Update table menggunakan tsvector

UPDATE table SET (col1_keywords, col2_keywords, col3_keywords) = (to_tsvector(col1), to_tsvector(col1 || ' ' || col2), to_tsvector(col1 || ' ' || col2 || ' ' || col3))

Kemudian, create index untuk column keyword tersebut.

CREATE INDEX namadma_dun_par_idx ON daerahmengundifull USING gin(namadma_dun_par_keywords)