Re: select distinct inet bug

Fixed in PostgreSQL 7.0, which was just released.

> 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

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026