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, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings