Re: How to get around LIKE inefficiencies?

Philip Warner <pjw@rhyme.com.au> writes:
> Could you trick it into not using the index (AND using the other strategy?)
> by using a calculation:

>    AND ( (url.url || ' ') LIKE 'http://www.postgresql.org/% ');

> it's a bit nasty.

Looks like a great kluge to me ;-)
        regards, tom lane