Home > mailing lists

Extract only numbers from a varchar column - Mailing list pgsql-general

From	Leandro Casadei
Subject	Extract only numbers from a varchar column
Date	May 6, 2008 12:38:44
Msg-id	5983afbb0805051008t2c714837y1052d11273b3529f@mail.gmail.com Whole thread Raw
List	pgsql-general

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

From: "Leandro Casadei"
Date: 06 May 2008, 12:38:34
Subject: Re: Extract only numbers from a varchar column

From: Michael Enke
Date: 06 May 2008, 12:39:00
Subject: CREATE CHARSET would be nice feature