Re: Free Text Search - Mailing list pgsql-general

From Mitch Vincent
Subject Re: Free Text Search
Date
Msg-id 00c901c0b602$772b7360$6e00000a@venux.net
Whole thread Raw
In response to Re: Free Text Search  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
Responses Re: Free Text Search  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
List pgsql-general
Well, full text searching can be accomplished by using any standard SQL
query (SELECT * FROM whatever WHERE textfield LIKE '%doda%' -- etc).. Full
text indexing is another story though.. I'll send some links when I get home
to some code that I've found here and there that looks promising..

-Mitch

----- Original Message -----
From: "Brett W. McCoy" <bmccoy@chapelperilous.net>
To: "McMillen Tom" <McMillT@EU.MWHSE.COM>
Cc: <pgsql-general@postgresql.org>
Sent: Sunday, March 25, 2001 10:10 PM
Subject: Re: Free Text Search


> On Fri, 23 Mar 2001, McMillen Tom wrote:
>
> > I have heard that there is no free text search with PostgreSQL but can
find
> > nothing to confirm/deny this.
> >
> > Is there free text search?
> >
> > If not are there any plans for it (I can't see it in the TODO's)
>
> Full text searching isn't built into PostgreSQL but there is a full text
> search library in the contrib directory of the source distribution that
> you can compile and use in PostgreSQL.
>
> -- Brett
>    http://www.chapelperilous.net/btfwk/
> ------------------------------------------------------------------------
> Marriage always demands the greatest understanding of the art of
> insincerity possible between two human beings.
> -- Vicki Baum
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>


pgsql-general by date:

Previous
From: "Richard Huxton"
Date:
Subject: Re: Adjustment to "Problem with dropping a FOREIGN KEY"
Next
From: Tom Lane
Date:
Subject: Re: MACADDR types NULL value (undocumented?)