Home > mailing lists

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

From	xu fei
Subject	FTS uses "tsquery" directly in the query
Date	January 23, 2010 21:21:49
Msg-id	754019.39258.qm@web45412.mail.sp1.yahoo.com Whole thread Raw
Responses	Re: FTS uses "tsquery" directly in the query
List	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!

From: John R Pierce
Date: 23 January 2010, 18:09:21
Subject: Re: Slow Query / Check Point Segments

From: Craig Ringer
Date: 23 January 2010, 21:58:28
Subject: Re: [LibPQ] Trying PQconnectStart: it doesn't seem to connect