Re: FTS uses "tsquery" directly in the query - Mailing list pgsql-general

From Oleg Bartunov
Subject Re: FTS uses "tsquery" directly in the query
Date
Msg-id Pine.LNX.4.64.1001241010570.16860@sn.sai.msu.ru
Whole thread Raw
In response to FTS uses "tsquery" directly in the query  (xu fei <autofei@yahoo.com>)
Responses Re: FTS uses "tsquery" directly in the query
List pgsql-general
Xu,

FTS has nothing with your problem, it's general limitation/feature.

Oleg
On Sat, 23 Jan 2010, xu fei wrote:

> Hi, everyone:
> First I can successful run this query:select name, ts_rank_cd(vectors, query) as rank from element,
to_tsquery('item')query where query @@ vectors order by rank desc;But actually I want to run this one:select name,
ts_rank_cd(vectors,query) as rank from element, 'item'::tsquery query where query @@ vectors order by rank desc;Looks
likethat FTS does not support directly use "::tsquery " in such query. Do I misunderstand something?  Thanks! 
> Xu
>
>
>

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Recursion in triggers?
Next
From: Alban Hertroys
Date:
Subject: Re: Recursion in triggers?