inet

I've got the following table structure for storing IPs (PostgreSQL 11.14): CREATE TABLE ips ( ip INET ); INSERT INTO ips VALUES ('10.0.0.4'); INSERT INTO ips VALUES ('10.0.0.0/24'); INSERT INTO ips VALUES ('10.1.0.0/23'); INSERT INTO ips VALUES ('10.1.0.0/27'); I need…