Re: Free Text Search
Mitch Vincent <mitch@venux.net>
From: "Mitch Vincent" <mitch@venux.net>
To: "Brett W. McCoy" <bmccoy@chapelperilous.net>, "McMillen Tom" <McMillT@EU.MWHSE.COM>
Cc: <pgsql-general@postgresql.org>
Date: 2001-03-26T14:38:46Z
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@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 >