Re: [HACKERS] How to get around LIKE inefficiencies?

[Tom Lane]

Philip Warner <[EMAIL PROTECTED]> 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