Re: [despammed] converting varchar to integer - Mailing list pgsql-sql

At 05:30 AM 8/17/05, Kretschmer Andreas wrote:

>tv@fuzzy.cz <tv@fuzzy.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;