Re: [PERFORM] Optimizing t1.col like '%t2.col%'

2008-02-27 Thread Tom Lane
"Dan Kaplan" <[EMAIL PROTECTED]> writes: > I've got a lot of rows in one table and a lot of rows in another table. I > want to do a bunch of queries on their join column. One of these is like > this: t1.col like '%t2.col%' > I know that always sucks. I'm wondering how I can make it better. tse

[PERFORM] Optimizing t1.col like '%t2.col%'

2008-02-27 Thread Dan Kaplan
I've got a lot of rows in one table and a lot of rows in another table. I want to do a bunch of queries on their join column. One of these is like this: t1.col like '%t2.col%' I know that always sucks. I'm wondering how I can make it better. First, I should let you know that I can likely ho