Re: regular expression searches - Mailing list pgsql-general

From David Fetter
Subject Re: regular expression searches
Date
Msg-id 20041007225849.GC28359@fetter.org
Whole thread Raw
In response to regular expression searches  ("David Bitner" <bitner@macnoise.com>)
Responses Question from a newbie
List pgsql-general
On Thu, Oct 07, 2004 at 04:07:08PM -0500, David Bitner wrote:
> I am trying to create a PL/PGSQL function that can parse a street address
> into the component parts (i.e. "200 W 54th Street" into num->200 dir->W
> street->54th type->ST).
>
> What I would like is to be able to use regular expressions within PL/PGSQL
> to accomplish this using mapping tables for the different components.

Perhaps PL/Perl or PL/Python would be more appropriate for this.

Cheers,
D
--
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

pgsql-general by date:

Previous
From: Robby Russell
Date:
Subject: Re: 8.0 questions
Next
From: Greg Stark
Date:
Subject: Re: Index problem.... GIST (tsearch2)