Bug #670: netmask displayed for a /32 - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #670: netmask displayed for a /32
Date
Msg-id 20020521112229.7540F475A03@postgresql.org
Whole thread Raw
Responses Re: Bug #670: netmask displayed for a /32
List pgsql-bugs
Edwin Groothuis (edwin@mavetju.org) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
netmask displayed for a /32

Long Description
The documentation says (chapter 3.8.1):
The input format for this type is x.x.x.x/y where x.x.x.x is an IP address and y is the number of bits in the netmask.
Ifthe /y part is left off, then the netmask is 32, and the value represents just a single host. On display, the /y
portionis suppressed if the netmask is 32. 

This works fine in this case:
pmoanalysis=> select ipaddress from dhcpservers;
 ipaddress
-----------
 1.2.3.4
(1 row)

But the /y portion is shown in this case:
pmoanalysis=> select ipaddress||'a' from dhcpservers;
  ?column?
-------------
 1.2.3.4/32a
(1 row)

I'm running pgsql version 7.2 under FreeBSD


Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Bug with Daylight Savings Time & Interval
Next
From: Mathieu Arnold
Date:
Subject: pg_dump && aggregate bug