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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
