[SQL] Feature, my misconception or bug??

2006-02-22 Thread Achilleus Mantzios
In PgSQL 7.4.12, 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. foodb=# SELECT '255.255.255.255/25'::cidr; cidr 255.255.255.255/25 (1 row) foodb=# in this case

Re: [SQL] Feature, my misconception or bug??

2006-02-22 Thread Peter Eisentraut
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 ... has no bits set to right of

Re: [SQL] Feature, my misconception or bug??

2006-02-22 Thread Markus Schaber
Hi, Peter, Peter Eisentraut wrote: 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 ... has no

Re: [SQL] Feature, my misconception or bug??

2006-02-22 Thread Markus Schaber
Achilleus Mantzios wrote: In PgSQL 7.4.12, 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. foodb=# SELECT '255.255.255.255/25'::cidr; cidr 255.255.255.255/25 (1 row)

Re: [SQL] Feature, my misconception or bug??

2006-02-22 Thread Achilleus Mantzios
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

Re: [SQL] Feature, my misconception or bug??

2006-02-22 Thread Achilleus Mantzios
O Markus Schaber έγραψε στις Feb 22, 2006 : Achilleus Mantzios wrote: In PgSQL 7.4.12, 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. foodb=# SELECT '255.255.255.255/25'::cidr;