X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 49E879F944D for ; Mon, 1 May 2006 08:45:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 08716-06 for ; Mon, 1 May 2006 08:45:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id C646B9FA3A6 for ; Mon, 1 May 2006 08:45:19 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 75AA530F1C; Mon, 1 May 2006 13:45:18 +0200 (MET DST) From: "mlartz@gmail.com" X-Newsgroups: pgsql.sql Subject: Re: join on a like Date: 1 May 2006 04:45:11 -0700 Organization: http://groups.google.com Lines: 4 Message-ID: <1146483911.614478.77500@u72g2000cwu.googlegroups.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com In-Reply-To: User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.2) Gecko/20060308 Firefox/1.5.0.2,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: u72g2000cwu.googlegroups.com; posting-host=151.196.11.66; posting-account=hpADjAwAAABN5Lkl4wJ_Us9DXosY2bot To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/4 X-Sequence-Number: 25035 If you use a btree index on the column, you should be able to use it in the like: http://www.postgresql.org/docs/8.1/interactive/indexes-types.html.