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 === ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
