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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073