Postgres "is not contained by" operator for IP addresses or inet types

user_329700 0
Viewed 781

Postgres has an operator for determining whether an IP address is contained by a given range, for example:

SELECT * FROM clients WHERE ip_address <<= inet '10.0.0.0/16';

How could I filter for the reverse set, the set of addresses not in that subnet? The documentation of net functions does not seem to have an operator that can do this. https://www.postgresql.org/docs/12/functions-net.html

where-clause ip-address postgresql sql
1 Answers

Use NOT:

SELECT * 
FROM clients 
WHERE NOT (ip_address <<= inet '10.0.0.0/16');

Parentheses are not necessary, inet operators have higher precedence than boolean ones.

user_19957380
Related