Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A5FDA9FB9E3 for ; Wed, 28 Mar 2007 11:10:38 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 04881-02-2 for ; Wed, 28 Mar 2007 11:10:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web31804.mail.mud.yahoo.com (web31804.mail.mud.yahoo.com [68.142.207.67]) by postgresql.org (Postfix) with SMTP id 05EA29FB967 for ; Wed, 28 Mar 2007 11:10:28 -0300 (ADT) Received: (qmail 28208 invoked by uid 60001); 28 Mar 2007 14:10:26 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=fJXKCH/rYbsdh9ztKGPljhOPvT9JERdQvFuSsonLzRMuoVi3ZkwtJHq86ISRHh45VOBeXvDQHlE1VHYvFziUE+wFByW445jchLWbfu/IBpjXZcFzneUnkC3GaG+8hBw8flI/rYEFC+dpMHNrD9iJAOskNogUHm3QN4BiBLGqtcQ=; X-YMail-OSG: dGMphL0VM1kd3qfF2A79gOJJvs4PURMn5mJhdwlf6Um7EhUzzgu8bHxu5IeULCs4gRLAHcCUWQ-- Received: from [63.203.180.122] by web31804.mail.mud.yahoo.com via HTTP; Wed, 28 Mar 2007 07:10:26 PDT Date: Wed, 28 Mar 2007 07:10:26 -0700 (PDT) From: Richard Broersma Jr Subject: Re: Regular Expressions [progress] To: ezequias@fastcon.com.br, pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <540160.27049.qm@web31804.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.788 tagged_above=0 required=5 tests=AWL=-0.827, BAYES_20=-0.74, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447 X-Spam-Level: * X-Archive-Number: 200703/330 X-Sequence-Number: 27968 > Select * from myAddressTable where address similar to ('%(ELMO|ST.|258)%') > > But I still need to Separete all strings. What is it that you are trying to achieve? What string would you like to seperate? Regards, Richard Broersma Jr.