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 <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
