[GENERAL] tsearch2 match substrings in words

2006-03-04 Thread Muller Zsolt
Hi, Is it possible using tsearch2 to match a substring of an element of a ts_vec column? For example: I have a table with a ts_vec, and I have a field with text, and if there is a value in the field "I would like to match the beginning of the words" - and the ts_vec has " 'like':3 'match':5

Re: [GENERAL] tsearch2 match substrings

2006-03-03 Thread Abbath
Hello Teodor, Friday, March 3, 2006, 5:09:45 PM, you wrote: >> words" - and the ts_vec has " 'like':3 'match':5 'begin':7 ...etc" then it >> would be cool to create a query, which give me a headline for "begin" if I >> just use the "beg" (or "beg*" ) search expression. > Potentially yes, but wit

Re: [GENERAL] tsearch2 match substrings

2006-03-03 Thread Teodor Sigaev
words" - and the ts_vec has " 'like':3 'match':5 'begin':7 ...etc" then it would be cool to create a query, which give me a headline for "begin" if I just use the "beg" (or "beg*" ) search expression. Potentially yes, but without index support and it's needed to write your operator/function.

[GENERAL] tsearch2 match substrings

2006-03-03 Thread Abbath
Hi, Is it possible using tsearch2 to match a substring of an element of a ts_vec column? For example: I have a table with a ts_vec, and I have a field with text, and if there is a value in the field "I would like to match the beginning of the words" - and the ts_vec has " 'like':3 'match':5 'beg