Hie all ,
I've already post a similar messages but i don't see it into the mailing list so ...
Look at the following :
test=> create table ip_table (addr inet);
CREATE
test=> insert into ip_table values ('10.10.10.10');
INSERT 1403913 1
test=> insert into ip_table values ('10.10.10.11');
INSERT 1403914 1
test=> select distinct addr from ip_table ;
addr
-----------
10.10.10.10
10.10.10.11
(2 rows)
test=> insert into ip_table values ('10.10.10.10');
INSERT 1403915 1
test=> select distinct addr from ip_table ;
addr
-----------
10.10.10.10
10.10.10.10
10.10.10.11
(3 rows)
???? I've read there was some bugs with inet type but i have not see it .
It seems to appear when i insert a value , after a select distinct and not if i insert without look at the result .
Is anybody could help me ? (Postgresql 6.5.2 on a Debian )
Loic
loic@ext.cri74.org