pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: ezequias@fastcon.com.br
To: Richard Broersma Jr <rabroersma@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Re: Regular Expressions [progress]
Date: Wed, 28 Mar 2007 09:25:41 -0300
Message-ID: <web-47565318@correio2.docasdoporto.com.br> (raw)
In-Reply-To: <150597.94573.qm@web31808.mail.mud.yahoo.com>

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



view thread (2+ messages)  latest in thread

Message-ID: <web-47565318@correio2.docasdoporto.com.br>
Permalink:  ../web-47565318@correio2.docasdoporto.com.br/
Also on:    postgresql.org/message-id/web-47565318@correio2.docasdoporto.com.br

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ezequias@fastcon.com.br, rabroersma@yahoo.com
  Subject: Re: Regular Expressions [progress]
  In-Reply-To: <web-47565318@correio2.docasdoporto.com.br>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox