Re: [GENERAL] FTS uses "tsquery" directly in the query

2010-01-25 Thread xu fei
Hi, Ivan: I agree with you and also would like to 'hack' into the code. Current FTC is the best one in database system and a great building block to support more functions. I list some I can think about:choose "|" or "&" as an optional parameter for to_tsquery, to_tsvector.choose normalization o

Re: [GENERAL] FTS uses "tsquery" directly in the query

2010-01-25 Thread xu fei
n FTS? If so, how? Thank!  Xu --- On Sun, 1/24/10, Oleg Bartunov wrote: From: Oleg Bartunov Subject: Re: [GENERAL] FTS uses "tsquery" directly in the query To: "xu fei" Cc: pgsql-general@postgresql.org Date: Sunday, January 24, 2010, 2:11 AM Xu, FTS has nothing with your prob

[GENERAL] FTS uses "tsquery" directly in the query

2010-01-23 Thread xu fei
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 q