Postgres Pro
Downloads
Home   >   mailing lists

extract integer from string - Mailing list pgsql-general

From Ben Ausden
Subject extract integer from string
Date
Msg-id 4174BB57B89ED411A8BB000102A30F51220868@NAVY
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: vitthal
Date:
Subject: Reading the database in RAM
Next
From: "Pat M"
Date:
Subject: Re: My brain hurts - update field based on value of another table's field