pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedFull text search
8+ messages / 6 participants
[nested] [flat]
* Full text search
@ 2001-09-22 05:25 Sameer Maggon <sameermaggon@rediffmail.com>
2001-09-22 09:47 ` Re: Full text search Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 1 reply; 8+ messages in thread
From: Sameer Maggon @ 2001-09-22 05:25 UTC (permalink / raw)
To: pgsql-docs
hi,
As MSSQL server supports FTS, does PostgreSQL also supports or has some external module to support FTS
Sameer
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Full text search
2001-09-22 05:25 Full text search Sameer Maggon <sameermaggon@rediffmail.com>
@ 2001-09-22 09:47 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2001-09-22 19:33 ` Re: Full text search Roberto Mello <rmello@cc.usu.edu>
0 siblings, 1 reply; 8+ messages in thread
From: Christopher Kings-Lynne @ 2001-09-22 09:47 UTC (permalink / raw)
To: Sameer Maggon <sameermaggon@rediffmail.com>; +Cc: pgsql-docs
Hi Sameer,
There are two ways of doing full text indexing in pgsql.
1. Use the contrib/fulltextindex module. This is fairly simple in 7.1.3
and the docs explain how to use it. If you want to nidex muliple columns,
I suggest getting the fulltextindex module from CVS HEAD. It will compile
against 7.1.x, but now 7.0.x.
2. Use OpenFTS. Check out www.openfts.org (I think) or search the maling
list archives for openfts
Cheers,
Chris
On 22 Sep 2001,
Sameer Maggon wrote:
> hi,
>
> As MSSQL server supports FTS, does PostgreSQL also supports or has some external module to support FTS
>
> Sameer
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Full text search
2001-09-22 05:25 Full text search Sameer Maggon <sameermaggon@rediffmail.com>
2001-09-22 09:47 ` Re: Full text search Christopher Kings-Lynne <chriskl@familyhealth.com.au>
@ 2001-09-22 19:33 ` Roberto Mello <rmello@cc.usu.edu>
0 siblings, 0 replies; 8+ messages in thread
From: Roberto Mello @ 2001-09-22 19:33 UTC (permalink / raw)
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>; +Cc: pgsql-docs
On Sat, Sep 22, 2001 at 05:47:30PM +0800, Christopher Kings-Lynne wrote:
>
> 2. Use OpenFTS. Check out www.openfts.org (I think) or search the maling
> list archives for openfts
http://openfts.sourceforge.net
OpenFTS seems to be very very good, offering lots of juicy features,
including interfaces to other languages.
Dan Wickstrom, from the OpenACS team (http://openacs.org) wrote the
OpenFTS interface to Tcl and AOLserver.
-Roberto
--
+------------| Roberto Mello - http://www.brasileiro.net |------------+
Computer Science, Utah State University - http://www.usu.edu
USU Free Software & GNU/Linux Club - http://fslc.usu.edu
Space Dynamics Lab, Developer - http://www.sdl.usu.edu
OpenACS - Enterprise free web toolkit - http://openacs.org
Never play leapfrog with a unicorn.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Full text search
@ 2001-09-22 11:09 Sameer Maggon <sameermaggon@rediffmail.com>
2001-09-23 08:47 ` Re: Full text search Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 1 reply; 8+ messages in thread
From: Sameer Maggon @ 2001-09-22 11:09 UTC (permalink / raw)
To: pgsql-docs
Hi,
Can u please tell which doc explains this feature
I saw the contrib directory and the fulltextindex
Please help
Sameer
>1. Use the contrib/fulltextindex module. This is
>fairly simple in 7.1.3
>and the docs explain how to use it. If you want to
>nidex muliple columns,
>I suggest getting the fulltextindex module from CVS
>HEAD. It will compile
>against 7.1.x, but now 7.0.x.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Full text search
2001-09-22 11:09 Re: Full text search Sameer Maggon <sameermaggon@rediffmail.com>
@ 2001-09-23 08:47 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
0 siblings, 0 replies; 8+ messages in thread
From: Christopher Kings-Lynne @ 2001-09-23 08:47 UTC (permalink / raw)
To: Sameer Maggon <sameermaggon@rediffmail.com>; +Cc: pgsql-docs
Hi Sameer,
It's documented really in two places:
1. In the contrib/README for docs regarding to all contribs
2. In the contrib/fulltextindex/README.fti for docs regarding to fti
I suggest you might want to read/install the fulltextindex module from CVS
as it's had its documentation greatly upgraded.
Chris
On 22 Sep 2001, Sameer Maggon wrote:
> Hi,
> Can u please tell which doc explains this feature
>
> I saw the contrib directory and the fulltextindex
>
> Please help
>
> Sameer
>
>
>
> >1. Use the contrib/fulltextindex module. This is
> >fairly simple in 7.1.3
> >and the docs explain how to use it. If you want to
> >nidex muliple columns,
> >I suggest getting the fulltextindex module from CVS
> >HEAD. It will compile
> >against 7.1.x, but now 7.0.x.
>
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Full Text Search
@ 2023-10-29 11:22 PG Doc comments form <noreply@postgresql.org>
2023-10-29 21:02 ` Re: Full Text Search David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: PG Doc comments form @ 2023-10-29 11:22 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: julien.champalbert@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/textsearch-limitations.html
Description:
Hello,
In the FTS/Limitations part of the documentation, it says :
"Another example — the PostgreSQL mailing list archives contained 910,989
unique words with 57,491,343 lexemes in 461,020 messages."
How could the number of lexemes be greater than unique words ?
Thank you
Julien
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Full Text Search
2023-10-29 11:22 Full Text Search PG Doc comments form <noreply@postgresql.org>
@ 2023-10-29 21:02 ` David G. Johnston <david.g.johnston@gmail.com>
2023-10-30 09:00 ` Re: Full Text Search Julien Champalbert <julien.champalbert@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: David G. Johnston @ 2023-10-29 21:02 UTC (permalink / raw)
To: julien.champalbert@gmail.com; pgsql-docs@lists.postgresql.org
On Sun, Oct 29, 2023, 13:58 PG Doc comments form <noreply@postgresql.org>
wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/14/textsearch-limitations.html
> Description:
>
> Hello,
>
> In the FTS/Limitations part of the documentation, it says :
>
> "Another example — the PostgreSQL mailing list archives contained 910,989
> unique words with 57,491,343 lexemes in 461,020 messages."
>
> How could the number of lexemes be greater than unique words ?
>
https://www.postgresql.org/docs/14/textsearch-parsers.html
Note the part with the hyphenated word example.
David J.
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Full Text Search
2023-10-29 11:22 Full Text Search PG Doc comments form <noreply@postgresql.org>
2023-10-29 21:02 ` Re: Full Text Search David G. Johnston <david.g.johnston@gmail.com>
@ 2023-10-30 09:00 ` Julien Champalbert <julien.champalbert@gmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Julien Champalbert @ 2023-10-30 09:00 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; pgsql-docs@lists.postgresql.org
Thank you David for your response, it makes sense now.
Julien
> Le 29 oct. 2023 à 22:02, David G. Johnston <david.g.johnston@gmail.com> a écrit :
>
> On Sun, Oct 29, 2023, 13:58 PG Doc comments form <noreply@postgresql.org <mailto:noreply@postgresql.org>> wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/14/textsearch-limitations.html <https://www.postgresql.org/docs/14/textsearch-limitations.html;
> Description:
>
> Hello,
>
> In the FTS/Limitations part of the documentation, it says :
>
> "Another example — the PostgreSQL mailing list archives contained 910,989
> unique words with 57,491,343 lexemes in 461,020 messages."
>
> How could the number of lexemes be greater than unique words ?
>
>
> https://www.postgresql.org/docs/14/textsearch-parsers.html <https://www.postgresql.org/docs/14/textsearch-parsers.html;
>
> Note the part with the hyphenated word example.
>
> David J.
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2023-10-30 09:00 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-09-22 05:25 Full text search Sameer Maggon <sameermaggon@rediffmail.com>
2001-09-22 09:47 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2001-09-22 19:33 ` Roberto Mello <rmello@cc.usu.edu>
2001-09-22 11:09 Re: Full text search Sameer Maggon <sameermaggon@rediffmail.com>
2001-09-23 08:47 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2023-10-29 11:22 Full Text Search PG Doc comments form <noreply@postgresql.org>
2023-10-29 21:02 ` Re: Full Text Search David G. Johnston <david.g.johnston@gmail.com>
2023-10-30 09:00 ` Re: Full Text Search Julien Champalbert <julien.champalbert@gmail.com>
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