Postgresql INET select and default route ?

[Tim Smith <randomdev4+postgres@xxxxxxxxx>]

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)  ?


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general