From: <ezequias@fastcon.com.br>
Subject: Re: Regular Expressions [progress]
To: Richard Broersma Jr <rabroersma@yahoo.com>,pgsql-sql@postgresql.org
Date: Wed, 28 Mar 2007 09:25:41 -0300
Message-ID: <web-47565318@correio2.docasdoporto.com.br>
In-Reply-To: <150597.94573.qm@web31808.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"; format="flowed"
Content-Transfer-Encoding: 8bit

Richards and List,

Now I find out the 'similar to' statement where I can do such search, but I 
must still parse all substrings.

Here is my stage:

Select * from myAddressTable where address similar to ('%(ELMO|ST.|258)%')

But I still need to Separete all strings.

Could someone help me in this crusade ?

Regards
Ezequias


Em Tue, 27 Mar 2007 15:16:10 -0700 (PDT)
  Richard Broersma Jr <rabroersma@yahoo.com> escreveu:
>> Could you give me a hand ?
>> 
>> I have a ZipCode table and my address table
>> 
>> I just would like to find out all matches that my zipcode table has where my 
>> address table appears like this:
>> 
>> Elmo Street, 30
>> 
>> I would like my SQL find out all matches we can find 'Elmo', 'Street'.
>> 
>
>select zipcode
>from zipzodetable
>where address ~ 'Elmo'
>and address ~ 'Street';
>
>If the query is too slow I expect that installing the tsearch2 contrib module 
>and using the
>tsearch2 type queries would give you want you wanted but in a fraction of the 
>time.
>
>Regards,
>Richard Broersma Jr.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend

--
Ezequias Rodrigues da Rocha