Re: Feature, my misconception or bug?? - Mailing list pgsql-sql

From Achilleus Mantzios
Subject Re: Feature, my misconception or bug??
Date
Msg-id Pine.LNX.4.44.0602221816400.12391-100000@matrix.gatewaynet.com
Whole thread Raw
In response to Re: Feature, my misconception or bug??  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
O Peter Eisentraut έγραψε στις Feb 22, 2006 :

> Am Mittwoch, 22. Februar 2006 13:04 schrieb Achilleus Mantzios:
> > foodb=# SELECT '255.255.255.255/24'::cidr;
> > ERROR:  invalid cidr value: "255.255.255.255/24"
> > DETAIL:  Value has bits set to right of mask.
> 
> > in this case
> > 11111111.11111111.11111111.11111111
> > has no bits set to right of
> >                      8 LSB ^
> 
In the above statement there was a "?", which is missing here.

It should read:
"in this case 11111111.11111111.11111111.11111111 has no bits set to 
right of 8th Least Significant Bit???"
(with a ^ showing the position where the mask ends, making it 
obviously visible to the ones who use text base MUAs in fixed width font
terminals).

In other words, why doesnt the system produce an error for the second 
query as well???

> I'm sure you are aware that "1" is a set bit, so which part are you not 
> understanding?

Others (Marcus) have reported that the second query 
SELECT '255.255.255.255/25'::cidr;
indeed produces an error in 8.1;

so i guess its a bug in the 7.4.x series.

> 
> 

-- 
-Achilleus



pgsql-sql by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Feature, my misconception or bug??
Next
From: Mario Splivalo
Date:
Subject: 'locking' the SELECTs based on indices...