Re: [GENERAL] testing castability of VARCHAR data to INET/CIDR

2005-07-23 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2005-07-23 06:04:55 -0600: > On Sat, Jul 23, 2005 at 11:31:23AM +0200, Roman Neuhauser wrote: > > > > I have a VARCHAR column containing mostly ip addresses, with an > > occasional piece of junk, and would like to transfer this data to an > > INET column. The UPDATE (SET inet

Re: [GENERAL] testing castability of VARCHAR data to INET/CIDR

2005-07-23 Thread Michael Fuhr
On Sat, Jul 23, 2005 at 11:31:23AM +0200, Roman Neuhauser wrote: > > I have a VARCHAR column containing mostly ip addresses, with an > occasional piece of junk, and would like to transfer this data to an > INET column. The UPDATE (SET inet_col = CAST(vc_col AS INET)) aborts > as soon as it hits an