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

am  17.08.2005, um 12:46:01 -0400 mailte Frank Bax folgendes:
> >>    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;

Yes, of corse. Thank you.


Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    ===