Postgresql INET select and default route ?

From: Tim Smith <randomdev4+postgres(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Postgresql INET select and default route ?
Date: 2015-12-09 11:20:51
Message-ID: CA+HuS5GepG=NssfmQQosVRLmbxn+kGcLTMz224pACz_ByaMdRg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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) ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2015-12-09 12:45:38 Re: Postgresql INET select and default route ?
Previous Message Albe Laurenz 2015-12-09 09:28:41 Re: Function in PostgreSQL