On Tue, May 21, 2002 at 10:12:20AM -0400, Tom Lane wrote:
> pgsql-bugs@postgresql.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@mavetju.org | Interested in MUDs? Visit Fatal Dimensions:
bash$ :(){ :|:&};: | http://www.FatalDimensions.org/