Re: Lexicographic index ? - Mailing list pgsql-general

From arnaud.mlist1@free.fr
Subject Re: Lexicographic index ?
Date
Msg-id 1021548128.3ce39660e5d56@imp.free.fr
Whole thread Raw
In response to Re: Lexicographic index ?  ("Marin Dimitrov" <marin.dimitrov@sirma.bg>)
List pgsql-general
> > select * from twords where words||'%' like 'saxophones';
> >
> > works but uses a sequential scan on the table...
> >

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

Hmmm... I don't think this has any chance to work : what I need is that a part
of the work I search (beginning from its start) can be found in the table (such
as 'saxophones' would match 'saxophone' or 'sax' in the table, but
not 'saxophonesandsomethingbehind', and not that the word can be found in a
bigger word in the table (it's already easy to find 'saxophones'
from 'saxophone' using like and 'saxophone%' : it uses my index correctly.

Or didn't I understand something ?
Arnaud

pgsql-general by date:

Previous
From: Arindam Haldar
Date:
Subject: Re: if exists?
Next
From: Arindam Haldar
Date:
Subject: Re: [INTERFACES] C & C ++Program Problem