Postgresql INET select and default route ? - Mailing list pgsql-general

From Tim Smith
Subject Postgresql INET select and default route ?
Date
Msg-id CA+HuS5GepG=NssfmQQosVRLmbxn+kGcLTMz224pACz_ByaMdRg@mail.gmail.com
Whole thread Raw
Responses Re: Postgresql INET select and default route ?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
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)  ?


pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: Function in PostgreSQL
Next
From: Albe Laurenz
Date:
Subject: Re: Postgresql INET select and default route ?