| 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: | Whole Thread | Raw Message | 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
| 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 |