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@ext.cri74.org


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