On Wed, 16 Nov 2005, Alexander Presber wrote:
> Hello,
>
> I have a question that arose while using tsearch on a large database of book
> information.
>
> In order to inject unstemmed + stemmed versions of searchstrings into a query
> we want to cast an expression of type text to tsquery.
> Unfortunately
>
> SELECT 'word'::tsquery
>
> (where the literal 'word' is of type 'unknown' seemingly) works just fine
> while e.g.
>
> SELECT ('word' || '&fullword')::tsquery
>
> or, simpler
>
> SELECT 'word&fullword'::text::tsquery
>
> gives
>
> ERROR: cannot cast type text to tsearch2.tsquery
>
> How can we work around that? Thanks for any help
no workaround needed. to_tsquery provides everything you need. If you
want fancy-shmancy solution you could always write wrapper around tsquery, but
I doubt you enter queries by hand, so why do you bothering ?
>
> Sincerely yours
> Alexander Presber
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83