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
>
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" |