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=#


--
Jon

--
Sent via pgsql-bugs mailing list (pgsql-bugs (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

On Tue, Jan 31, 2012 at 10:38 AM, Jon Nelson <jnelson+pgsql (AT) jamponi (DOT) net> wrote:
What were you expecting to get? There's no such thing as a negative IP address.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

--
Sent via pgsql-bugs mailing list (pgsql-bugs (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

On Tue, Jan 31, 2012 at 2:03 PM, Robert Haas <robertmhaas (AT) gmail (DOT) com> wrote:
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 (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Jon Nelson <jnelson+pgsql (AT) jamponi (DOT) net> writes:
The inet minus inet operator is defined to yield bigint, so it only
copes for addresses within 2^63 of each other. Short of inventing an
integer type at least 129 bits wide, the only way we could fix this is
to make the operator return numeric instead, which doesn't really seem
like an improvement for typical use-cases. I'm fairly sure this was
debated when the operator was added, and we thought it was an acceptable
limitation; though maybe with IPv6 finally starting to see real usage
it's going to seem less so.

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs