Re: Bug #670: netmask displayed for a /32

On Tue, May 21, 2002 at 10:12:20AM -0400, Tom Lane wrote:
> 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.

I've already changed it to use host(), was just a message to let
you know that it might not have been working the way you expected
it to do.

Thanks for your reply and the database, it rocks :-)

Edwin

--
Edwin Groothuis | Personal website: http://www.MavEtJu.org
edwin(at)mavetju(dot)org | Interested in MUDs? Visit Fatal Dimensions:
bash$ :(){ :|:&};: | http://www.FatalDimensions.org/