Thread: Free Text Search

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)

Thanks

Tom

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

On Fri, Mar 23, 2001 at 08:18:26AM -0000, 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)

and the regex (or even 'like') will operate on gargantuan
text fields, i think (tho you'll pay for it)...

--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
        -- Isaac Asimov, 'The Genetic Code'

will@serensoft.com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

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
>

At 09:38 AM 26-03-2001 -0500, Mitch Vincent wrote:
>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..

Would that GIST thing help? If it does, any ideas how?

So far the way I might resort to  is at the application level.

It'll be nice to be able to do a LIKE '%post%' and have it indexed for at
least some tables.

e.g. create index blah on tablename (lower(data) fulltextops)

Cheerio,
Link.