At 05:30 AM 8/17/05, Kretschmer Andreas wrote:
>tv(at)fuzzy(dot)cz <tv(at)fuzzy(dot)cz> 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;