From: | Loïc TREGOUËT <loic(at)cri74(dot)org> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | select distinct inet bug |
Date: | 2000-05-23 07:42:03 |
Message-ID: | 392A364B.1274A042@ext.cri74.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)ext(dot)cri74(dot)org
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Vazsonyi | 2000-05-23 09:58:47 | postgres instability? |
Previous Message | Tom Lane | 2000-05-23 04:59:57 | Re: port v7.0 to SGI-IRIX-6.5.7/64 |