Re: [GENERAL] Postgresql INET select and default route ?

Fabuous ! Thank you ! On 14 December 2015 at 07:52, Albe Laurenz wrote: > Tim Smith wrote: >> Re: I am surprised that you don't expect "0.0.0.0/0" to be returned by the >> first >> query if you expect it to be returned by the second. >> Is that an oversicht? >> >>

Re: [GENERAL] Postgresql INET select and default route ?

Hi Albe, Apologies for the delayed reply. Re: I am surprised that you don't expect "0.0.0.0/0" to be returned by the first query if you expect it to be returned by the second. Is that an oversicht? Thanks for the question, but no, it wasn't an oversight, I only am looking for 0.0.0.0/0 to be

Re: [GENERAL] Postgresql INET select and default route ?

Tim Smith wrote: > Re: I am surprised that you don't expect "0.0.0.0/0" to be returned by the > first > query if you expect it to be returned by the second. > Is that an oversicht? > > Thanks for the question, but no, it wasn't an oversight, I only am > looking for 0.0.0.0/0 to be returned if

Re: [GENERAL] Postgresql INET select and default route ?

Tim Smith wrote: > 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'; >

[GENERAL] Postgresql INET select and default route ?

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)