22 Nov 2005
PostgreSQL Full Text Search

Implementing Full Text Indexing with PostgreSQL

1. on Fedora Core 3 rpm -ql postgresql-contrib

2. read the tsearch2.README

3. psql blikidb < /usr/share/pgsql/contrib/tsearch2.sql

ALTER TABLE public.wikipage ADD COLUMN vectors tsvector; CREATE INDEX markup_index ON wikipage USING gist(vectors); SELECT set_curcfg(‘default’); UPDATE wikipage SET vectors = to_tsvector(‘default’, markup); SELECT entry_id,headline(description,q),

comments powered by Disqus