Horton

Re: How to get around LIKE inefficiencies?

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Philip Warner <pjw@rhyme.com.au>
Cc: The Hermit Hacker <scrappy@hub.org>, pgsql-hackers@postgresql.org
Date: 2000-11-06T02:59:03Z
Lists: pgsql-hackers 
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