FTS uses "tsquery" directly in the query

Поиск

Список

Период

Сортировка

От	xu fei
Тема	FTS uses "tsquery" directly in the query
Дата	24 января 2010 г. 00:21:49
Msg-id	754019.39258.qm@web45412.mail.sp1.yahoo.com обсуждение исходный текст
Ответы	Re: FTS uses "tsquery" directly in the query
Список	pgsql-general

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 like that FTS does not support directly use "::tsquery " in such query. Do I misunderstand something? Thanks!

В списке pgsql-general по дате отправления:

От: John R Pierce
Дата: 23 января 2010 г., 21:09:21
Сообщение: Re: Slow Query / Check Point Segments

От: Craig Ringer
Дата: 24 января 2010 г., 00:58:28
Сообщение: Re: [LibPQ] Trying PQconnectStart: it doesn't seem to connect