hi...
> insert into ip values (10.20.30.40);
>
> It always points to the third part of the IP (ie, 100
> in case of 10.30.100.200)
>
pgsql is seeing it as a decimal number. enclose it in single quotes and it will
work fine.
insert into ip values ('10.20.30.40');
--
Aaron J. Seigo
Sys Admin