select distinct inet bug

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

Responses

Browse pgsql-admin by date

  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