Re: [GENERAL] access to lexems or access to parsed elements

2011-08-25 Thread Sushant Sinha
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

Re: [GENERAL] Profiling postgres

2008-07-27 Thread Sushant Sinha
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

Re: [GENERAL] Fragments in tsearch2 headline

2008-05-22 Thread Sushant Sinha
. 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

Re: [GENERAL] Fragments in tsearch2 headline

2008-03-28 Thread Sushant Sinha
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

[GENERAL] tsearch2 word separators

2008-03-13 Thread Sushant Sinha
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

[GENERAL] tsearch2: stop words and stemming separate?

2008-01-26 Thread Sushant Sinha
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)

Re: [GENERAL] Fragments in tsearch2 headline

2007-11-11 Thread Sushant Sinha
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

Re: [GENERAL] Fragments in tsearch2 headline

2007-10-30 Thread Sushant Sinha
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