Re: Regular Expressions [progress]

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(at)yahoo(dot)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