Evenin'
What I discovered just lately is a nice feature from pgsql that I can test
if a specific IP address falls within a supplied subnet:
myserver=# select inet '192.168.0.1' << '192.168.0.0/24'::inet as ip;
ip
----
t
(1 row)
But what I don't understand is why pgsql doesn't behave correctly when testing for a /32 subnet:
(it works for /31 correctly though)
myserver=# select inet '192.168.0.1' << '192.168.0.1/32'::inet as ip;
ip
----
f
From a network engineering point of view this should also return "true" and not false.
Has this been fixed in recent versions? I'm using 9.2.8 right now….
thanks in advance
richard