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
