Postgresql - Return only numeric values from column

Return only numberic values from column

If you ever need to fetch the numeric values from a column, below query can help to achieve. The query was only tested with Postgresql and works like a charm.

select substring([COLUMN-NAME] FROM '[0-9]+') from [TABLE-NAME]

Reference: Stackoverflow