Re: Lexicographic index ? - Mailing list pgsql-general

From Marin Dimitrov
Subject Re: Lexicographic index ?
Date
Msg-id 00d101c1fcbe$040903d0$9ba1d53e@sirma.bg
Whole thread Raw
In response to Lexicographic index ?  (arnaud.mlist1@free.fr)
Responses Re: Lexicographic index ?
Re: Lexicographic index ?
List pgsql-general
----- Original Message -----
From: <arnaud.mlist1@free.fr>


>
> And what I want to built a query that tells me if a word given in argument
can
> be found at least partially in the database. Something like
>
> select * from twords where words||'%' like 'saxophones';
>
> works but uses a sequential scan on the table...
>


try http://techdocs.postgresql.org/techdocs/fulltextindexing.php

hth,

    Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "



pgsql-general by date:

Previous
From: arnaud.mlist1@free.fr
Date:
Subject: Lexicographic index ?
Next
From: "Marin Dimitrov"
Date:
Subject: Re: Is there eny e-mail server that uses postgreSQL as backend server for mailboxes&users