Re: Feature, my misconception or bug??

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Feature, my misconception or bug??
Date: 2006-02-22 16:31:45
Message-ID: Pine.LNX.4.44.0602221816400.12391-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Judith Altamirano Figueroa 2006-02-22 17:59:06 Update in all tables
Previous Message Irina Gadassik 2006-02-22 15:27:54 pg reserved words