Thread: url to free text search stategies in postgresql?

url to free text search stategies in postgresql?

From
Matthew Kennedy
Date:
There was a brief mention in the "RFC: PostgreSQL and MySQL comparison"
thread about "free text search" in postgresql. Is there any information
avaliable on this? Nothing came up when I searched the interactive
manual and the rest of the web. Does the term "free text search" simply
relate to the "LIKE" operator?

Thanks
Matthew


Re: url to free text search stategies in postgresql?

From
"Mitch Vincent"
Date:
Check the contrib directory of the PostgreSQL tarball..

-Mitch

----- Original Message -----
From: "Matthew Kennedy" <mkennedy@opushealthcare.com>
To: <pgsql-general@postgresql.org>
Sent: Wednesday, August 29, 2001 5:14 PM
Subject: [GENERAL] url to free text search stategies in postgresql?


> There was a brief mention in the "RFC: PostgreSQL and MySQL comparison"
> thread about "free text search" in postgresql. Is there any information
> avaliable on this? Nothing came up when I searched the interactive
> manual and the rest of the web. Does the term "free text search" simply
> relate to the "LIKE" operator?
>
> Thanks
> Matthew
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


Re: url to free text search stategies in postgresql?

From
Gunnar Rønning
Date:
* Matthew Kennedy <mkennedy@opushealthcare.com> wrote:
|
| There was a brief mention in the "RFC: PostgreSQL and MySQL comparison"
| thread about "free text search" in postgresql. Is there any information
| avaliable on this? Nothing came up when I searched the interactive

Check the openfts addon for postgresql at :

http://openfts.sourceforge.net/

You can also test it in action by searching the PostgreSQL mailing lists
at :

http://fts.postgresql.org/db/mw/

cheers,

        Gunnar

--
Gunnar Rønning - gunnar@polygnosis.com
Senior Consultant, Polygnosis AS, http://www.polygnosis.com/

Re: url to free text search stategies in postgresql?

From
"Karen Ellrick"
Date:
I would be interested in full text search capabilities that would work in
Multibyte mode.  I don't get the impression that either
.../contrib/fulltextsearch/ or Open FTS would work on, say, Japanese (which
is what I need) - both seem to operate by interpreting the data as words and
phrases and breaking it up into substrings, but Japanese writing doesn't use
spaces to separate words, so I have no idea how those tools would choose
substrings.  I am building a web page for FAQ's that includes searching, but
all my current code (PHP-based, BTW) would allow the user to search on is
one string of text (I just take whatever they input and do a LIKE on each of
my two text-type fields "question" and "answer").  If I allow multiple
search strings I would need multiple LIKE phrases, and I'm afraid the speed
of the query would go down the tubes, since LIKE (or ~*) doesn't use
indexes, right?  I don't necessarily need anything super sophisticated,
since it's not searching the world but just our product FAQs, but I want it
to be reasonably efficient.  At a minimum, maybe someone can tell me pros
and cons to using LIKE versus ~* if I start expanding to allow multiple
search strings - is there a performance difference?  I can't really test the
speed very well because there is no real data yet - that will be somebody
else's job after I'm done with the code.

Any thoughts?

--------------------------------
Karen Ellrick
S & C Technology, Inc.
1-21-35 Kusatsu-shinmachi
Hiroshima  733-0834  Japan
(from U.S. 011-81, from Japan 0) 82-293-2838
--------------------------------

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Gunnar Rønning
> Sent: Thursday, August 30, 2001 5:25 PM
> To: Matthew Kennedy
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] url to free text search stategies in postgresql?
>
>
> * Matthew Kennedy <mkennedy@opushealthcare.com> wrote:
> |
> | There was a brief mention in the "RFC: PostgreSQL and MySQL comparison"
> | thread about "free text search" in postgresql. Is there any information
> | avaliable on this? Nothing came up when I searched the interactive
>
> Check the openfts addon for postgresql at :
>
> http://openfts.sourceforge.net/
>
> You can also test it in action by searching the PostgreSQL mailing lists
> at :
>
> http://fts.postgresql.org/db/mw/
>
> cheers,
>
>         Gunnar
>
> --
> Gunnar Rønning - gunnar@polygnosis.com
> Senior Consultant, Polygnosis AS, http://www.polygnosis.com/
>
> ---------------------------(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