Postgres Pro
Downloads
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
Msg-id 754019.39258.qm@web45412.mail.sp1.yahoo.com
Whole thread Raw
Responses Re: FTS uses "tsquery" directly in the query  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Slow Query / Check Point Segments
Next
From: Craig Ringer
Date:
Subject: Re: [LibPQ] Trying PQconnectStart: it doesn't seem to connect