Previous   Next 

Adding Stop Words

SELECT * FROM to_tsvector('default', 'Halt is not a stop word.');

        to_tsvector
----------------------------
 'halt':1 'stop':5 'word':6
(1 row)

Exit psql. As root, add 'halt' to the bottom of the file english.stop.

tail -n 5 /usr/local/pgsql/share/contrib/english.stop

don
should
now
halt

Start a new psql session to reload english.stop.

SELECT * FROM to_tsvector('default', 'Halt is now a stop word.');

    to_tsvector
-------------------
 'stop':5 'word':6
(1 row)