inet type , select distinct troubles

From: Loïc TREGOUËT <loic(at)cri74(dot)org>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: inet type , select distinct troubles
Date: 2000-05-22 13:22:28
Message-ID: 39293494.DD7163C1@cri74.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hie all ,

I've a big database ( 2M rows ) and i use the inet type for ip
address .

for example :

test=>create table ip_table (i int4 , addr inet );
CREATE

The i do a lot of inserts in my database , with Perl/DBI . (Note i
use AutoCommit=off for performance) :

test=>select count(*) from table_ip ;
500 000 rows //It's normal !

Then i want to select all the ip @ who are different , so

test=>select distinct addr from ip_table ;
192.168.10.10
192.168.10.10
......
10.10.10.10
10.10.10.10
.....
20000 rows //It's not normal !!!!!!

The given address are fictive but the result have some bugs ? Isn't
it ?

It seems that the egality test failed ?

Any response or suggestions would be apreciate .

loic(at)cri74(dot)org

Browse pgsql-admin by date

  From Date Subject
Next Message Murad Nayal 2000-05-22 16:42:48 port v7.0 to SGI-IRIX-6.5.7/64
Previous Message Nicolas Huillard 2000-05-21 16:37:46 RE: using ssh for network authentication