Re: Yet another LIKE-indexing scheme

On Sat, Sep 02, 2000 at 01:39:47PM -0400, Tom Lane wrote:
> > So what happens with "WHERE name like 'Czec%`" ?
> 
> Our existing code fails because it generates WHERE name >= 'Czec' AND
> name < 'Czed'; it will therefore not find names beginning 'Czech'
> because those are in another part of the index, between 'Czeh' and
> 'Czei'.  But WHERE name >= 'Cze' AND name < 'Czf' would work.

(OK, I haven't read the previous discussion.  Guilty, m'lud)

Why should it?  If 'ch' is one letter, then surely 'czech' isn't LIKE
'czec%'.  Because 'czec%' has a second c, wheres, 'czech' only has one
'c' and one 'ch'?

Jules