Can this fit?
select plainto_tsquery('english', 'the quick brown fox jumped over the
lazy fox');
plainto_tsquery
-
'quick' & 'brown' & 'fox' & 'jump' & 'lazi' & 'fox'
-Sushant.
On Thu, 2011-08-25 at 18:21
configure postgres with the following options
1. ./configure --enable-profiling
2. make and make install
3. start psql and issue the query
4. gmon.out will be in the data directory once you exit from psql
-Sushant.
On Sun, 2008-07-27 at 05:55 -0700, Suresh wrote:
>
> Hello,
>
> I want to prof
. One way to do this will be to invoke it only when options
like MaxCoverSize is used. It will be slightly ugly though.
It still seems to have bugs. I will try to clean that up.
-Sushant.
On Thu, 2008-05-22 at 13:31 +0200, Pierre-Yves Strub wrote:
> Hi,
>
> I've ported the pa
Ah I missed this email. I agree with Teodor that this is not the best
way to implement this functionality. At the time I was in a bit of hurry
to have something better than the default one and just hacked this. And
if we want to have this functionality across languages and parsers it
will be better
A document may contain date in the traditional format. For example it
may contain '11/1/2007'. It will be useful if we can directly search for
year in a document. However, the 'default' tsearch2 parser does not
break down integers separated by '/'. So I my search for '2007' will not
match tsvector
I want to remove stop words but do not want to stem the words. Is there
an interface in tsearch2 that allows me to do this?
Basically I am trying to implement spelling corrections and do not want
to correct stop words.
Thanks,
-Sushant.
---(end of broadcast)
I wrote a headline generation function for my app and I have attached
the patch (against the cvs head). It generates multiple contexts in
which the query appears. Essentially, it uses the cover function to
generate all covers, chooses smallest covers and stretches each
selected cover according to t
This is a nice idea and seems easy to implement. I will try to write
it down and send a patch to the mailing list.
I was also working to add support for phrase search. Currently to
check for phrase you have to match the entire document. It will be
better if a filter like are_words_consecutive(tsve