Enclose the IP in single quotes.
insert into ip values ('10.20.30.40');
--------------------------------------------------------------------------
Aaron Holtz
ComNet Inc.
UNIX Systems Administration/Network Operations
"It's not broken, it just lacks duct tape."
--------------------------------------------------------------------------
On Oct 21, soundar rajan molded the electrons to say....
>Hi all,
>
>I created two tables with CIDR and inet data values
>separately. I was not able to insert values into it.
>When I tries to do
>
>insert into ip values (10.20.30.40);
>
>the error I get time and again is
>
>'parser error at or near .30'
>
>It always points to the third part of the IP (ie, 100
>in case of 10.30.100.200)
>
>Any help be appreciated.
>
>Thanks
>
>
>__________________________________________________
>Do You Yahoo!?
>Bid and sell for free at http://auctions.yahoo.com
>
>************
>
************
