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
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 |