Re: String searching

Jonathan Vanasco-7 wrote
> The reason is that GIN/GIST use language patterns to simplify the index.
> so they work great on "words"
>
> select plainto_tsquery('doing watching reading programming');
> 'watch' & 'read' & 'program'
>
> but not so great on "names":
>
> select plainto_tsquery('john doe');
> 'john' & 'doe'
>
> select plainto_tsquery('jon doe');
> 'jon' & 'doe

Going from memory here so take with a cave full of salt...

This doesn't help the OP but full text search is simply a single user of
gin/gist index families; there are others. The two features are related but
operate at different levels of abstraction/interaction.

At a cursory glance I would think trigram would be a good fit here...but as
I've never used it personally I could be way off base. The idea being to
figure out whether the smaller string's trigrams all exist in the larger
string.

David J.

--
View this message in context: http://postgresql.nabble.com/String-searching-tp5827268p5827320.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.