On Tue, Jan 31, 2012 at 2:03 PM, Robert Haas <robertmh...@gmail.com> wrote: > On Tue, Jan 31, 2012 at 10:38 AM, Jon Nelson <jnelson+pg...@jamponi.net> > wrote: >> Example (using one of google's IPv6 addrs): >> >> jnelson=# select inet '0::0' - inet '2001:4860:4006:800::1011'; >> ERROR: result is out of range >> jnelson=# > > What were you expecting to get? There's no such thing as a negative IP > address.
True, but it works for IPv4: jnelson=# select inet '255.255.255.255' - inet '0/0'; ?column? ------------ 4294967295 (1 row) Time: 0.417 ms jnelson=# select inet '0/0' - inet '255.255.255.255'; ?column? ------------- -4294967295 (1 row) Time: 0.166 ms jnelson=# If it makes you happy, reverse the arguments and try it again. -- Jon -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
