OpenACS is shifting support to tsearch2. This web site is using tsearch2. You can check out the tsearch2-driver package for the code that shows how OpenACS interacts with the tsearch2 code in PostgreSQL.
http://cvs.openacs.org/cvs/openacs-4/packages/tsearch2-driver/
