regress/sql/inet.sql

8 CREATE TABLE INET_TBL (c cidr, i inet);
30 INSERT INTO INET_TBL (c, i) VALUES (cidr('192.168.1.2/30'), '192.168.1.226');
31 INSERT INTO INET_TBL (c, i) VALUES (cidr('ffff:ffff:ffff:ffff::/24'), '::192.168.1.226');
32 SELECT '' AS ten, c AS cidr, i AS inet FROM INET_TBL;
37 SELECT '' AS ten, c AS cidr, broadcast(c),
39 SELECT '' AS ten, c AS cidr, network(c) AS "network(cidr)",
41 SELECT '' AS ten, c AS cidr, masklen(c) AS "masklen(cidr)",
44 SELECT '' AS four, c AS cidr, masklen(c) AS "masklen(cidr)",
48 SELECT '' AS six, c AS cidr, i AS inet FROM INET_TBL
69 SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr;
70 SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr;
72 SELECT * FROM inet_tbl WHERE i<<='192.168.1.0/24'::cidr;
73 SELECT * FROM inet_tbl WHERE i<<='192.168.1.0/24'::cidr;
75 SELECT * FROM inet_tbl WHERE '192.168.1.0/24'::cidr >>= i;
76 SELECT * FROM inet_tbl WHERE '192.168.1.0/24'::cidr >>= i;
78 SELECT * FROM inet_tbl WHERE '192.168.1.0/24'::cidr >> i;
79 SELECT * FROM inet_tbl WHERE '192.168.1.0/24'::cidr >> i;
86 SELECT * FROM inet_tbl WHERE i << '192.168.1.0/24'::cidr ORDER BY i;
87 SELECT * FROM inet_tbl WHERE i <<= '192.168.1.0/24'::cidr ORDER BY i;
88 SELECT * FROM inet_tbl WHERE i && '192.168.1.0/24'::cidr ORDER BY i;
89 SELECT * FROM inet_tbl WHERE i >>= '192.168.1.0/24'::cidr ORDER BY i;
90 SELECT * FROM inet_tbl WHERE i >> '192.168.1.0/24'::cidr ORDER BY i;
91 SELECT * FROM inet_tbl WHERE i < '192.168.1.0/24'::cidr ORDER BY i;
92 SELECT * FROM inet_tbl WHERE i <= '192.168.1.0/24'::cidr ORDER BY i;
93 SELECT * FROM inet_tbl WHERE i = '192.168.1.0/24'::cidr ORDER BY i;
94 SELECT * FROM inet_tbl WHERE i >= '192.168.1.0/24'::cidr ORDER BY i;
95 SELECT * FROM inet_tbl WHERE i > '192.168.1.0/24'::cidr ORDER BY i;
96 SELECT * FROM inet_tbl WHERE i <> '192.168.1.0/24'::cidr ORDER BY i;
100 SELECT i FROM inet_tbl WHERE i << '192.168.1.0/24'::cidr ORDER BY i;
101 SELECT i FROM inet_tbl WHERE i << '192.168.1.0/24'::cidr ORDER BY i;
109 SELECT * FROM inet_tbl WHERE i << '192.168.1.0/24'::cidr ORDER BY i;
110 SELECT * FROM inet_tbl WHERE i <<= '192.168.1.0/24'::cidr ORDER BY i;
111 SELECT * FROM inet_tbl WHERE i && '192.168.1.0/24'::cidr ORDER BY i;
112 SELECT * FROM inet_tbl WHERE i >>= '192.168.1.0/24'::cidr ORDER BY i;
113 SELECT * FROM inet_tbl WHERE i >> '192.168.1.0/24'::cidr ORDER BY i;
114 SELECT * FROM inet_tbl WHERE i < '192.168.1.0/24'::cidr ORDER BY i;
115 SELECT * FROM inet_tbl WHERE i <= '192.168.1.0/24'::cidr ORDER BY i;
116 SELECT * FROM inet_tbl WHERE i = '192.168.1.0/24'::cidr ORDER BY i;
117 SELECT * FROM inet_tbl WHERE i >= '192.168.1.0/24'::cidr ORDER BY i;
118 SELECT * FROM inet_tbl WHERE i > '192.168.1.0/24'::cidr ORDER BY i;
119 SELECT * FROM inet_tbl WHERE i <> '192.168.1.0/24'::cidr ORDER BY i;
123 SELECT i FROM inet_tbl WHERE i << '192.168.1.0/24'::cidr ORDER BY i;
124 SELECT i FROM inet_tbl WHERE i << '192.168.1.0/24'::cidr ORDER BY i;