Re: [HACKERS] tsearch thoughts

2002-12-02 Thread Teodor Sigaev
I mean, when the index is created over the text column, instead of just indexing the text as-is, index the txt2txtidx'd version...? For two reasons: 1. gist_txtidx_ops create with loss information (for less size), so any operation with index must be checked with original txtidx value. The way "

Re: [HACKERS] tsearch thoughts

2002-12-01 Thread Christopher Kings-Lynne
> This is sort of we had thought about full text searching in postgres and > what should happens with maturity of tsearch. We began from contrib/module > just to get some experience and still need to do some research on > underlying algorithms. Also, remember current GiST is not concurrent and > w

Re: [HACKERS] tsearch thoughts

2002-12-01 Thread Oleg Bartunov
On Sat, 30 Nov 2002, Christopher Kings-Lynne wrote: > Is there any reason why the tseach indexes couldn't be modified to just work > on TEXT fields and not TXTIDX fields. Is there really a reason to have the > TXTIDX type? > > I mean, when the index is created over the text column, instead of jus