Re: FTS uses "tsquery" directly in the query

Поиск
Список
Период
Сортировка
От Oleg Bartunov
Тема Re: FTS uses "tsquery" directly in the query
Дата
Msg-id Pine.LNX.4.64.1001241010570.16860@sn.sai.msu.ru
обсуждение исходный текст
Ответ на FTS uses "tsquery" directly in the query  (xu fei <autofei@yahoo.com>)
Ответы Re: FTS uses "tsquery" directly in the query  (xu fei <autofei@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: "Gauthier, Dave"
Дата:
Сообщение: Recursion in triggers?
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Recursion in triggers?