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),