Andreas Degert <ad(at)papyrus-gmbh(dot)de> writes:
> the .. >= .. < .. condition will result in addtional matches, like 'fo ot',
> so you still have to check with LIKE.
Of course. The point of all this is just to create a "prefilter" that can
be implemented by scanning an index, so that most of the rows in the
table need not be visited at all when the LIKE pattern has the right
form. But the original LIKE operator is still executed as part of the
WHERE condition for each row.
regards, tom lane