Re: Inet type how to?

Yes, I know that; but even when I reload it, copy complains it can't
convert 194.250.190.185 ( for example) to inet!

Regards
On Fri, 2 Jun 2000, Alex Pilosov wrote:

> You cannot change column type without dropping/recreating the table.
> 
> On Fri, 2 Jun 2000, Olivier PRENANT wrote:
> 
> > Hi all,
> > 
> > I've had a table for years to keep radius connections to our NAS.
> > 
> > Not havin inet type, I typed ip_adress as text. Now, I'em trying to change
> > this column type to no avail.
> > 
> > select inet(ip_addr)... : cannot cast type to inet
> > 
> > How can I change this column??
> > 
> > TIA
> > 
> > 
> 

-- 
Olivier PRENANT             Tel:    +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)