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 [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
