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
|
Список | 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 по дате отправления: