Received: from ns1.via-net-works.net.ar (ns1.via-net-works.net.ar [200.10.100.10]) by postgresql.org (Postfix) with ESMTP id 81B35476629; Fri, 22 Feb 2002 13:46:53 -0500 (EST) Received: (from fpscha@localhost) by ns1.via-net-works.net.ar (8.9.3/8.9.3) id PAA81259; Fri, 22 Feb 2002 15:46:48 -0300 (ART) X-Authentication-Warning: ns1.via-net-works.net.ar: fpscha set sender to fschapachnik@vianetworks.com.ar using -f Date: Fri, 22 Feb 2002 15:46:48 -0300 From: Fernando Schapachnik To: "Samuel J. Sutjiono" Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: [SQL] Regular Expression for 'and' instead of 'or' Message-ID: <20020222154648.F2066@ns1.via-net-works.net.ar> References: <023101c1bbc3$03a33910$110a010a@headquarters.wcgroup.com> <20020222151514.E2066@ns1.via-net-works.net.ar> <025b01c1bbcf$81dccc40$110a010a@headquarters.wcgroup.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.2.5i In-Reply-To: <025b01c1bbcf$81dccc40$110a010a@headquarters.wcgroup.com>; from ssutjiono@wc-group.com on Fri, Feb 22, 2002 at 01:34:04PM -0500 X-Archive-Number: 200202/1071 X-Sequence-Number: 21068 En un mensaje anterior, Samuel J. Sutjiono escribió: > Thank you very much Fernando. Do you know whether this expression (regex) > use index scan ? Not sure, but probably an EXPLAIN will tell. Good luck. Fernando P. Schapachnik Gerente de tecnología de red y sistemas de información VIA NET.WORKS ARGENTINA S.A. fschapachnik@vianetworks.com.ar Tel.: (54-11) 4323-3381