Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group