Hi,
create table test(a inet);
insert into test values ('0.0.0.0/0');
insert into test values ('10.1.2.3');
=> select * from test;
a
-----------
0.0.0.0/0
10.1.2.3
(2 rows)
This works as expected .....
=> select * from test where a <<= '10.1.2.3';
a
----------
10.1.2.3
(1 row)
This does not work as expected ....
=> select * from test where a <<= '11.1.2.3';
a
---
(0 rows)
Surely the second one should return the default route entry (i.e. 0.0.0.0/0) ?