---------- Forwarded message ---------- From: Leandro Casadei <[EMAIL PROTECTED]> Date: May 5, 2008 2:08 PM Subject: Extract only numbers from a varchar column To: pgsql-general@postgresql.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') != ''
