Skip site navigation (1) Skip section navigation (2)

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

From: Edwin Groothuis <edwin(at)mavetju(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Bug #670: netmask displayed for a /32
Date: 2002-05-23 04:43:15
Message-ID: 20020523144315.X560@k7.mavetju.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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/

In response to

pgsql-bugs by date

Next:From: Terence IngramDate: 2002-05-23 06:52:19
Subject: Numeric Datatype
Previous:From: Tom LaneDate: 2002-05-23 02:33:21
Subject: Re: Inherited tables and pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group