Re: Free Text Search

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net>, "McMillen Tom" <McMillT(at)EU(dot)MWHSE(dot)COM>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Free Text Search
Date: 2001-03-26 14:38:46
Message-ID: 00c901c0b602$772b7360$6e00000a@venux.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)chapelperilous(dot)net>
To: "McMillen Tom" <McMillT(at)EU(dot)MWHSE(dot)COM>
Cc: <pgsql-general(at)postgresql(dot)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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-26 14:45:27 Re: MACADDR types NULL value (undocumented?)
Previous Message Richard Huxton 2001-03-26 14:22:56 Re: Adjustment to "Problem with dropping a FOREIGN KEY"