At 05:30 AM 8/17/05, Kretschmer Andreas wrote:
[EMAIL PROTECTED] <[EMAIL PROTECTED]> schrieb:> Hi, > > I have a varchar column, and I need to > > 1) check the value in it is an integer > 2) get the integer value (as integer) test=# update foo set n = substring(t , '[0-9]')::int;
I think you meant:
update foo set n = substring(t , '[0-9]+')::int;
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
