"James Reynolds" <jamex@xxxxxxxxxxxx> writes: > I want to convert a TEXT string that I am mangling to TSVECTOR with a cast. > I am using Postgresql 8.1.6 and tsearch2. > According to the documentation this should work although I am getting an > ERROR. > tsearch2 reference on www.sai.msu.su says that > text::TSVECTOR RETURNS TSVECTOR Seems to be a documentation mistake, since there's no CREATE CAST anywhere in the tsearch.sql file (either in 8.1 or later versions). I think you want to use to_tsvector(). regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly