[SQL] GiST and full text search

2003-09-22 Thread Wei Weng
Hi all. I have been doing a little research on how to do full text search under postgresql, and GiST seems to be the way to go. But the documentation on this is pretty lacking and I wonder if there are better sources that describe the details on how to implement full text search with GiST.

Re: [SQL] GiST and full text search

2003-09-22 Thread Richard Huxton
On Monday 22 September 2003 16:02, Wei Weng wrote: Hi all. I have been doing a little research on how to do full text search under postgresql, and GiST seems to be the way to go. But the documentation on this is pretty lacking and I wonder if there are better sources that describe the

Re: [SQL] GiST and full text search

2003-09-22 Thread Wei Weng
The production server uses PostgreSQL 7.3.1 right now, so I am only looking at contrib/tsearch. I read through the README file. It only seems to offer a way to FTS through one 'text' column in the table. How do I create a 'txtidx' column that combines two or even more 'text' columns in the

Re: [SQL] GiST and full text search

2003-09-22 Thread Richard Huxton
On Monday 22 September 2003 16:41, Wei Weng wrote: The production server uses PostgreSQL 7.3.1 right now, so I am only looking at contrib/tsearch. I read through the README file. It only seems to offer a way to FTS through one 'text' column in the table. How do I create a 'txtidx' column

Re: [SQL] GiST and full text search

2003-09-22 Thread Andrew J. Kopciuch
On Monday 22 September 2003 09:41, Wei Weng wrote: The production server uses PostgreSQL 7.3.1 right now, so I am only looking at contrib/tsearch. tsearch2 is compatible, and available for any version of PosgreSQL 7.3. It is not included in the contrib directory. It is available in CVS head

Re: [SQL] GiST and full text search

2003-09-22 Thread Oleg Bartunov
On Mon, 22 Sep 2003, Wei Weng wrote: The production server uses PostgreSQL 7.3.1 right now, so I am only looking at contrib/tsearch. you may download tsearch2 for 7.3.X from http://www.sai.msu.su/~megera/postgres/gist/tsearc/V2 I read through the README file. It only seems to offer a way to