Re: incompatible return type for netmask(inet) function between 7.0.3 and 7.1

Justin Clift wrote:
> 

For 7.0.3 I already found solution for this problem, thanks.
I ask now about why logical same functions host(inet) and netmask(inet)
return different types ?

> Hi Vadim,
> 
> I don't know if this is of any help, but it might be...
> 
> With PostgreSQL 7.0.x, there was a bug with the way inet type data was
> being returned.  It was being given out as text, but with spaces used
> for padding stuck on the end of the string.
> 
> i.e.  '192.168.1.1     '
> 
> This was fixed in 7.1.
> 
> i.e. '192.168.1.1'
> 
> Depending on how you're doing things, you *might* be able to wrap stuff
> in a btrim() function for 7.0.x.
> 
> i.e. btrim(<inet_field>) should return '192.168.1.1'
> 
> Well, you get the idea.  Might be a start of a workaround for you
> anyway.
> 
> Regards and best wishes,
> 
> Justin Clift
> 
> pgsql-bugs@postgresql.org wrote:
> >
> > Vadim Passynkov (pvi@axxent.ca) reports a bug with a severity of 4
> > The lower the number the more severe it is.
> >
> > Short Description
> > incompatible return type for netmask(inet) function between 7.0.3 and 7.1
> >
> > Long Description
> > Function netmask(inet) change return type from 7.0.3 to 7.1
> > In 7.0.3 return type was text, in 7.1 return type inet
> > Realy in 7.1 added text(inet) and of course need that
> > host and netmask have return type inet, but host in 7.1 still return
> > text.
> >
> > Other problem this changes that dump code from 7.0.3 incompatible
> > with 7.1.
> >
> > Sample Code
> > Version 7.0.3
> > template1=# \df netmask
> >        List of functions
> >  Result | Function | Arguments
> > --------+----------+-----------
> >  text   | netmask  | inet
> > (1 row)
> >
> > template1=# \df host
> >        List of functions
> >  Result | Function | Arguments
> > --------+----------+-----------
> >  text   | host     | inet
> > (1 row)
> >
> > Version 7.1
> > template1=# \df netmask
> >        List of functions
> >  Result | Function | Arguments
> > --------+----------+-----------
> >  inet   | netmask  | inet
> > (1 row)
> >
> > template1=# \df host
> >        List of functions
> >  Result | Function | Arguments
> > --------+----------+-----------
> >  text   | host     | inet
> > (1 row)
> >
> > No file was uploaded with this report
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> >     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 
> --
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
>      - Indira Gandhi

-- 

 Vadim I. Passynkov, Axxent Corp.
 mailto:pvi@axxent.ca