Re: int to inet conversion [or Re: inet to bigint?]

We have a patch for this for application to 8.2.

---------------------------------------------------------------------------

Volkan YAZICI wrote:
> On Dec 08 04:36, Kai wrote:
> > After working regularly with inet values in sql, it would be nice to be able
> > to do this:
> > 
> >     => select '192.168.1.1'::inet + 1 as result;
> >        result    
> >     -------------
> >      192.168.1.2
> >     (1 row)
> 
> You may take a look at ip4r[1] project too. For a full list for its
> availabilities (like +/- operators) here[2] is the related SQL file.
> 
> [1] http://pgfoundry.org/projects/ip4r/
> [2] http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/~checkout~/ip4r/ip4r/ip4r.sql.in?rev=1.4&content-type=text/plain
> 
> 
> Regards.
> 
> -- 
> "We are the middle children of history, raised by television to believe
> that someday we'll be millionaires and movie stars and rock stars, but
> we won't. And we're just learning this fact," Tyler said. "So don't
> fuck with us."
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073