Re: tsearch2 text::TSVECTOR cast not working for me on Pg 8.1.6

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jamex(at)taraketh(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: tsearch2 text::TSVECTOR cast not working for me on Pg 8.1.6
Date: 2008-02-11 21:45:42
Message-ID: 10071.1202766342@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"James Reynolds" <jamex(at)taraketh(dot)net> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Willem Buitendyk 2008-02-11 21:58:36 SPI_ERROR_CONNECT
Previous Message James Reynolds 2008-02-11 20:37:18 tsearch2 text::TSVECTOR cast not working for me on Pg 8.1.6