Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA82002 for ; Wed, 11 Aug 1999 18:36:56 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id SAA09517; Wed, 11 Aug 1999 18:35:46 -0400 (EDT) To: Clayton Cottingham cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] quest:optimization with indexes In-reply-to: Your message of Wed, 11 Aug 1999 17:43:30 +0000 <37B1B641.5AD0DC0C@smartt.com> Date: Wed, 11 Aug 1999 18:35:46 -0400 Message-ID: <9515.934410946@sss.pgh.pa.us> From: Tom Lane Clayton Cottingham writes: > thanks for all those 'like' tips i was wonderinng, would using regex be the > same as far as the indexing rules go? It's equivalent --- an index can help if the pattern is anchored to the start of the string. Of course the pattern notation is different... regards, tom lane