Fabuous ! Thank you ! On 14 December 2015 at 07:52, Albe Laurenz <laurenz.albe@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
