On Wed, Mar 22, 2017 at 1:21 AM, Dilip Kumar <dilipbal...@gmail.com> wrote: > postgres=# SELECT * FROM inet_tbl WHERE i <> '192.168.1.0/24'::cidr > ORDER BY i; > c | i > --------------------+------------------ > 10.0.0.0/8 | 9.1.2.3/8 > 10.0.0.0/8 | 10.1.2.3/8 > 10.0.0.0/32 | 10.1.2.3/8 > 10.0.0.0/8 | 10.1.2.3/8 > 10.1.0.0/16 | 10.1.2.3/16 > 10.1.2.0/24 | 10.1.2.3/24 > 10.1.2.3/32 | 10.1.2.3 > 10.0.0.0/8 | 11.1.2.3/8 > 192.168.1.0/24 | 192.168.1.226/24 > 192.168.1.0/24 | 192.168.1.255/24 > 192.168.1.0/24 | 192.168.1.0/25 > 192.168.1.0/24 | 192.168.1.255/25 > 192.168.1.0/26 | 192.168.1.226 > ::ffff:1.2.3.4/128 | ::4.3.2.1/24 > 10:23::f1/128 | 10:23::f1/64 > 10:23::8000/113 | 10:23::ffff > (16 rows)
Isn't that one row short? What happened to this one? 10.0.0.0/8 | 10::/8 -- Thomas Munro http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
