FTS uses "tsquery" directly in the query

From: xu fei <autofei(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: FTS uses "tsquery" directly in the query
Date: 2010-01-24 01:21:35
Message-ID: 754019.39258.qm@web45412.mail.sp1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!
Xu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2010-01-24 01:58:05 Re: [LibPQ] Trying PQconnectStart: it doesn't seem to connect
Previous Message John R Pierce 2010-01-23 22:08:51 Re: Slow Query / Check Point Segments