Bug #670: netmask displayed for a /32

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #670: netmask displayed for a /32
Date: 2002-05-21 11:22:29
Message-ID: 20020521112229.7540F475A03@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Edwin Groothuis (edwin(at)mavetju(dot)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. If the /y part is left off, then the netmask is 32, and the value represents just a single host. On display, the /y portion is 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mathieu Arnold 2002-05-21 12:13:55 pg_dump && aggregate bug
Previous Message Josh Berkus 2002-05-21 05:57:46 Re: [SQL] Bug with Daylight Savings Time & Interval