[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
