Fabuous ! Thank you !
On 14 December 2015 at 07:52, Albe Laurenz <laurenz.albe@wien.gv.at> 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?
>>
>> 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 there is no more specific
>> match.
>
> I see, but then you'll have to use a different query:
>
> SELECT a from test where '11.1.2.3' <<= a
> ORDER BY masklen(a) DESC LIMIT 1;
>
> Yours,
> Laurenz Albe