extract integer from string

From: Ben Ausden <Ben(dot)Ausden(at)navyblue(dot)com>
To: "Pgsql-General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: extract integer from string
Date: 2001-09-26 12:59:38
Message-ID: 4174BB57B89ED411A8BB000102A30F51220868@NAVY
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message wsheldah 2001-09-26 13:03:14 Re: fun in redmond
Previous Message Brian C. Doyle 2001-09-26 12:35:03 Perl and Postgres