pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedGiST and full text search
6+ messages / 4 participants
[nested] [flat]
* GiST and full text search
@ 2003-09-22 15:02 Wei Weng <wweng@kencast.com>
0 siblings, 1 reply; 6+ messages in thread
From: Wei Weng @ 2003-09-22 15:02 UTC (permalink / raw)
To: pgsql-sql
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.
Thanks
Wei
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: GiST and full text search
@ 2003-09-22 15:24 Richard Huxton <dev@archonet.com>
parent: Wei Weng <wweng@kencast.com>
0 siblings, 1 reply; 6+ messages in thread
From: Richard Huxton @ 2003-09-22 15:24 UTC (permalink / raw)
To: Wei Weng <wweng@kencast.com>; pgsql-sql
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 details on how to implement full text search with GiST.
Have you looked at tsearch / tsearch2 in the contrib/ directory?
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: GiST and full text search
@ 2003-09-22 15:41 Wei Weng <wweng@kencast.com>
parent: Richard Huxton <dev@archonet.com>
0 siblings, 3 replies; 6+ messages in thread
From: Wei Weng @ 2003-09-22 15:41 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; +Cc: pgsql-sql
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 table?
Thanks
Wei
On Mon, 22 Sep 2003, Richard Huxton wrote:
> 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 details on how to implement full text search with GiST.
>
> Have you looked at tsearch / tsearch2 in the contrib/ directory?
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: GiST and full text search
@ 2003-09-22 16:55 Richard Huxton <dev@archonet.com>
parent: Wei Weng <wweng@kencast.com>
2 siblings, 0 replies; 6+ messages in thread
From: Richard Huxton @ 2003-09-22 16:55 UTC (permalink / raw)
To: Wei Weng <wweng@kencast.com>; +Cc: pgsql-sql
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
> that combines two or even more 'text' columns in the table?
According to README.tsearch from 7.4beta (not tsearch2 which is the new one)
Current syntax allows creating trigger for several columns
you want to be searchable:
create trigger txtidxupdate before update or insert on titles
for each row execute procedure tsearch(titleidx, title1, title2,... );
Perhaps see what 7.3.4's tsearch says - that should be compatible with 7.3.1
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: GiST and full text search
@ 2003-09-22 17:03 Andrew J. Kopciuch <akopciuch@olympusproject.org>
parent: Wei Weng <wweng@kencast.com>
2 siblings, 0 replies; 6+ messages in thread
From: Andrew J. Kopciuch @ 2003-09-22 17:03 UTC (permalink / raw)
To: Wei Weng <wweng@kencast.com>; Richard Huxton <dev@archonet.com>; +Cc: pgsql-sql
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 and will
be in 7.4 contrib AFAIK.
You can download the stable version here:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch-v2-stable.tar.gz
There are full installation instructions in the introdution. See below.
> 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 table?
>
Read the introduction documentation. It explains this in detail, plus many
other things you might want to know:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html
Andy
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: GiST and full text search
@ 2003-09-23 05:38 Oleg Bartunov <oleg@sai.msu.su>
parent: Wei Weng <wweng@kencast.com>
2 siblings, 0 replies; 6+ messages in thread
From: Oleg Bartunov @ 2003-09-23 05:38 UTC (permalink / raw)
To: Wei Weng <wweng@kencast.com>; +Cc: Richard Huxton <dev@archonet.com>; pgsql-sql
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 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 table?
>
> Thanks
>
> Wei
>
> On Mon, 22 Sep 2003, Richard Huxton wrote:
>
> > 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 details on how to implement full text search with GiST.
> >
> > Have you looked at tsearch / tsearch2 in the contrib/ directory?
> >
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2003-09-23 05:38 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-09-22 15:02 GiST and full text search Wei Weng <wweng@kencast.com>
2003-09-22 15:24 ` Richard Huxton <dev@archonet.com>
2003-09-22 15:41 ` Wei Weng <wweng@kencast.com>
2003-09-22 16:55 ` Richard Huxton <dev@archonet.com>
2003-09-22 17:03 ` Andrew J. Kopciuch <akopciuch@olympusproject.org>
2003-09-23 05:38 ` Oleg Bartunov <oleg@sai.msu.su>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox