EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Oleg Bartunov
Sent: Wednesday, February 27, 2008 9:47 PM
To: Dan Kaplan
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] t1.col like '%t2.col%'
On Wed, 27 Feb 2008, Dan Kaplan wrote:
> I've got a lot of rows in one t
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
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
