Re: Extract only numbers from a varchar column

---------- Forwarded message ----------
From: Leandro Casadei <mateamargo(at)gmail(dot)com>
Date: May 5, 2008 2:08 PM
Subject: Extract only numbers from a varchar column
To: pgsql-general(at)postgresql(dot)org

I need to extract only the first occurence of numbers from a column that is
varchar.

Here are a few examples of what I need to do:

abc200xx -> 200
340ppsdd -> 340
150ytyty555 -> 150

Can this be done by a simple query or do I need to use a cursor?

Thanks

I've finally solved this way:

select name, regexp_replace(name, '\\D*', '', 'g')::int as replaced
from sometable
where regexp_replace(name, '\\D*', '', 'g') != ''