Thread: extract integer from string

extract integer from string

From
Ben Ausden
Date:
hi,

does anyone know if there exists a Postgres function to extract the integer
portion of a text string?

e.g.

somefunc('109PL') --> 109
somefunc('Plot Number 106') --> 106


TIA,
ben


--
ben ausden
developer, navyblue new media
[t] 0131 553 0100
[f] 0131 553 1303
[e] benedict{at}navyblue.com