QUERY: DROP TABLE INET_TBL;ERROR:  Relation 'inet_tbl' does not existQUERY: CREATE TABLE INET_TBL (c cidr, i inet);QUERY: INSERT INTO INET_TBL (c, i) VALUES ('192.168.1', '192.168.1.226/24');QUERY: INSERT INTO INET_TBL (c, i) VALUES ('192.168.1.2/24', '192.168.1.226');QUERY: INSERT INTO INET_TBL (c, i) VALUES ('10', '10.1.2.3/8');QUERY: INSERT INTO INET_TBL (c, i) VALUES ('10.0.0.0', '10.1.2.3/8');QUERY: INSERT INTO INET_TBL (c, i) VALUES ('10.1.2.3', '10.1.2.3/32');QUERY: INSERT INTO INET_TBL (c, i) VALUES ('10.1.2', '10.1.2.3/24');QUERY: INSERT INTO INET_TBL (c, i) VALUES ('10.1', '10.1.2.3/16');QUERY: INSERT INTO INET_TBL (c, i) VALUES ('10', '10.1.2.3/8');QUERY: INSERT INTO INET_TBL (c, i) VALUES ('10', '11.1.2.3/8');QUERY: INSERT INTO INET_TBL (c, i) VALUES ('10', '9.1.2.3/8');QUERY: SELECT '' AS ten, c AS cidr, i AS inet FROM INET_TBL;ten|cidr        |inet            ---+------------+----------------   |192.168.1/24|192.168.1.226/24   |192.168.1/24|192.168.1.226      |10/8        |10.1.2.3/8         |10.0.0.0/32 |10.1.2.3/8         |10.1.2.3/32 |10.1.2.3           |10.1.2/24   |10.1.2.3/24        |10.1/16     |10.1.2.3/16        |10/8        |10.1.2.3/8         |10/8        |11.1.2.3/8         |10/8        |9.1.2.3/8       (10 rows)QUERY: SELECT '' AS ten, i AS inet, host(i) FROM INET_TBL;ten|inet            |         host---+----------------+-------------   |192.168.1.226/24|192.168.1.226   |192.168.1.226   |192.168.1.226   |10.1.2.3/8      |     10.1.2.3   |10.1.2.3/8      |     10.1.2.3   |10.1.2.3        |     10.1.2.3   |10.1.2.3/24     |     10.1.2.3   |10.1.2.3/16     |     10.1.2.3   |10.1.2.3/8      |     10.1.2.3   |11.1.2.3/8      |     11.1.2.3   |9.1.2.3/8       |      9.1.2.3(10 rows)QUERY: SELECT '' AS ten, c AS cidr, broadcast(c),  i AS inet, broadcast(i) FROM INET_TBL;ten|cidr        |      broadcast|inet            |      broadcast---+------------+---------------+----------------+---------------   |192.168.1/24|  192.168.1.255|192.168.1.226/24|  192.168.1.255   |192.168.1/24|  192.168.1.255|192.168.1.226   |255.255.255.255   |10/8        | 10.255.255.255|10.1.2.3/8      | 10.255.255.255   |10.0.0.0/32 |255.255.255.255|10.1.2.3/8      | 10.255.255.255   |10.1.2.3/32 |255.255.255.255|10.1.2.3        |255.255.255.255   |10.1.2/24   |     10.1.2.255|10.1.2.3/24     |     10.1.2.255   |10.1/16     |   10.1.255.255|10.1.2.3/16     |   10.1.255.255   |10/8        | 10.255.255.255|10.1.2.3/8      | 10.255.255.255   |10/8        | 10.255.255.255|11.1.2.3/8      | 11.255.255.255   |10/8        | 10.255.255.255|9.1.2.3/8       |  9.255.255.255(10 rows)QUERY: SELECT '' AS ten, c AS cidr, network(c) AS "network(cidr)",  i AS inet, network(i) AS "network(inet)" FROM INET_TBL;ten|cidr        |network(cidr)|inet            |network(inet)   ---+------------+-------------+----------------+----------------   |192.168.1/24|192.168.1/24 |192.168.1.226/24|192.168.1/24       |192.168.1/24|192.168.1/24 |192.168.1.226   |192.168.1.226/32   |10/8        |10/8         |10.1.2.3/8      |10/8               |10.0.0.0/32 |10.0.0.0/32  |10.1.2.3/8      |10/8               |10.1.2.3/32 |10.1.2.3/32  |10.1.2.3        |10.1.2.3/32        |10.1.2/24   |10.1.2/24    |10.1.2.3/24     |10.1.2/24          |10.1/16     |10.1/16      |10.1.2.3/16     |10.1/16            |10/8        |10/8         |10.1.2.3/8      |10/8               |10/8        |10/8         |11.1.2.3/8      |11/8               |10/8        |10/8         |9.1.2.3/8       |9/8             (10 rows)QUERY: SELECT '' AS ten, c AS cidr, masklen(c) AS "masklen(cidr)",  i AS inet, masklen(i) AS "masklen(inet)" FROM INET_TBL;ten|cidr        |masklen(cidr)|inet            |masklen(inet)---+------------+-------------+----------------+-------------   |192.168.1/24|           24|192.168.1.226/24|           24   |192.168.1/24|           24|192.168.1.226   |           32   |10/8        |            8|10.1.2.3/8      |            8   |10.0.0.0/32 |           32|10.1.2.3/8      |            8   |10.1.2.3/32 |           32|10.1.2.3        |           32   |10.1.2/24   |           24|10.1.2.3/24     |           24   |10.1/16     |           16|10.1.2.3/16     |           16   |10/8        |            8|10.1.2.3/8      |            8   |10/8        |            8|11.1.2.3/8      |            8   |10/8        |            8|9.1.2.3/8       |            8(10 rows)QUERY: SELECT '' AS four, c AS cidr, masklen(c) AS "masklen(cidr)",  i AS inet, masklen(i) AS "masklen(inet)" FROM INET_TBL  WHERE masklen(c) <= 8;four|cidr|masklen(cidr)|inet      |masklen(inet)----+----+-------------+----------+-------------    |10/8|            8|10.1.2.3/8|            8    |10/8|            8|10.1.2.3/8|            8    |10/8|            8|11.1.2.3/8|            8    |10/8|            8|9.1.2.3/8 |            8(4 rows)QUERY: SELECT '' AS six, c AS cidr, i AS inet FROM INET_TBL  WHERE c = i;six|cidr        |inet            ---+------------+----------------   |192.168.1/24|192.168.1.226/24   |10/8        |10.1.2.3/8         |10.1.2.3/32 |10.1.2.3           |10.1.2/24   |10.1.2.3/24        |10.1/16     |10.1.2.3/16        |10/8        |10.1.2.3/8      (6 rows)QUERY: SELECT '' AS ten, i, c,  i < c AS lt, i <= c AS le, i = c AS eq,  i >= c AS ge, i > c AS gt, i <> c AS ne,  i << c AS sb, i <<= c AS sbe,  i >> c AS sup, i >>= c AS spe  FROM INET_TBL;ten|i               |c           |lt|le|eq|ge|gt|ne|sb|sbe|sup|spe---+----------------+------------+--+--+--+--+--+--+--+---+---+---   |192.168.1.226/24|192.168.1/24|f |t |t |t |f |f |f |t  |f  |t     |192.168.1.226   |192.168.1/24|f |f |f |t |t |t |t |t  |f  |f     |10.1.2.3/8      |10/8        |f |t |t |t |f |f |f |t  |f  |t     |10.1.2.3/8      |10.0.0.0/32 |f |f |f |t |t |t |f |f  |t  |t     |10.1.2.3        |10.1.2.3/32 |f |t |t |t |f |f |f |t  |f  |t     |10.1.2.3/24     |10.1.2/24   |f |t |t |t |f |f |f |t  |f  |t     |10.1.2.3/16     |10.1/16     |f |t |t |t |f |f |f |t  |f  |t     |10.1.2.3/8      |10/8        |f |t |t |t |f |f |f |t  |f  |t     |11.1.2.3/8      |10/8        |f |f |f |t |t |t |f |f  |f  |f     |9.1.2.3/8       |10/8        |t |t |f |f |f |t |f |f  |f  |f  (10 rows)