Re: [GENERAL] pg_trgm module: no convertion into Trigrams on one side when comparing

2013-11-15 Thread Janek Sendrowski
Hi Amit, Do you think it would by difficult to edit the source and wirte a new function, wich does it?   Janek Sendrowski -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_trgm module: no convertion into Trigrams on one side when comparing

2013-11-14 Thread Amit Langote
On Thu, Nov 14, 2013 at 9:05 PM, Janek Sendrowski wrote: > Hi Amit, > > Thanks for your answer. > > My issue is that I still need a ranking like the similarity when comparing > trigrams. > I'm working on a similarity search, which determindes similiar sentences from > my table. > > The usual sim

Re: [GENERAL] pg_trgm module: no convertion into Trigrams on one side when comparing

2013-11-14 Thread Janek Sendrowski
Hi Amit,   Thanks for your answer. My issue is that I still need a ranking like the similarity when comparing trigrams. I'm working on a similarity search, which determindes similiar sentences from my table. The usual similarity search with Trigrams and a gist bzw. gin index is to slow with my

Re: [GENERAL] pg_trgm module: no convertion into Trigrams on one side when comparing

2013-11-13 Thread Amit Langote
On Thu, Nov 14, 2013 at 2:37 AM, Janek Sendrowski wrote: > Hi, > I'm using the pg_trgm module, > Is there a possibility not to convert one side of the string when comparing? > I need a kind of reference string containing only certain trigrams. > It's not possible to build every kind of string usin