Re: [GENERAL] Stemming not working with tsearch2() function

2007-04-30 Thread Oleg Bartunov
On Mon, 30 Apr 2007, psql psql wrote: On 4/30/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote: On Mon, 30 Apr 2007, psql psql wrote: > On 4/30/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote: >> >> On Mon, 30 Apr 2007, psql psql wrote: >> >> > Anyone know why to_tsvector('sausages') might return "sau

Re: [GENERAL] Stemming not working with tsearch2() function

2007-04-30 Thread psql psql
On 4/30/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote: On Mon, 30 Apr 2007, psql psql wrote: > On 4/30/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote: >> >> On Mon, 30 Apr 2007, psql psql wrote: >> >> > Anyone know why to_tsvector('sausages') might return "sausages" while >> > to_tsvector('default',

Re: [GENERAL] Stemming not working with tsearch2() function

2007-04-30 Thread Oleg Bartunov
On Mon, 30 Apr 2007, psql psql wrote: On 4/30/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote: On Mon, 30 Apr 2007, psql psql wrote: > Anyone know why to_tsvector('sausages') might return "sausages" while > to_tsvector('default','sausages') correctly returns "sausag"? > > This is causing me a fai

Re: [GENERAL] Stemming not working with tsearch2() function

2007-04-30 Thread psql psql
On 4/30/07, Oleg Bartunov <[EMAIL PROTECTED]> wrote: On Mon, 30 Apr 2007, psql psql wrote: > Anyone know why to_tsvector('sausages') might return "sausages" while > to_tsvector('default','sausages') correctly returns "sausag"? > > This is causing me a fairly major headache. I am guessing that t

Re: [GENERAL] Stemming not working with tsearch2() function

2007-04-30 Thread Oleg Bartunov
On Mon, 30 Apr 2007, psql psql wrote: Anyone know why to_tsvector('sausages') might return "sausages" while to_tsvector('default','sausages') correctly returns "sausag"? This is causing me a fairly major headache. I am guessing that the tsearch2() function used in my trigger is not specifying "

[GENERAL] Stemming not working with tsearch2() function

2007-04-30 Thread psql psql
Anyone know why to_tsvector('sausages') might return "sausages" while to_tsvector('default','sausages') correctly returns "sausag"? This is causing me a fairly major headache. I am guessing that the tsearch2() function used in my trigger is not specifying "default" when creating the tsvector sinc