Re: [GENERAL] regular expression searches

2004-10-07 Thread David Fetter
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 expressio

[GENERAL] regular expression searches

2004-10-07 Thread David Bitner
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 diffe