pgsql-bugs(at)postgresql(dot)org writes:
> But the /y portion is shown in this case:
> pmoanalysis=> select ipaddress||'a' from dhcpservers;
> ?column?
> -------------
> 1.2.3.4/32a
> (1 row)
This implicitly coerces the inet value to text datatype, and the
text(inet) function always displays netmask. Perhaps you'd prefer
to use host() or abbrev() to do the conversion to text.
regards, tom lane