1-- Tests for pg11+ 2-- RANGE support 3select a4, 4 array_agg(a4) over (order by a4 range between 268435456 preceding and 268435456 following) 5 from ipaddrs 6 where a4 is not null; 7 a4 | array_agg 8-----------------+------------------------------------------------------------- 9 12.174.29.15 | {12.174.29.15} 10 33.8.16.211 | {33.8.16.211} 11 55.224.125.146 | {55.224.125.146} 12 73.239.169.71 | {73.239.169.71,76.178.38.194} 13 76.178.38.194 | {73.239.169.71,76.178.38.194} 14 96.76.124.246 | {96.76.124.246,104.175.11.72} 15 104.175.11.72 | {96.76.124.246,104.175.11.72} 16 163.145.90.183 | {163.145.90.183} 17 189.85.58.60 | {189.85.58.60,195.58.214.186,203.156.110.93} 18 195.58.214.186 | {189.85.58.60,195.58.214.186,203.156.110.93} 19 203.156.110.93 | {189.85.58.60,195.58.214.186,203.156.110.93} 20 223.213.219.214 | {223.213.219.214,235.64.97.205} 21 235.64.97.205 | {223.213.219.214,235.64.97.205,240.116.30.226} 22 240.116.30.226 | {235.64.97.205,240.116.30.226,254.251.8.237,255.226.130.53} 23 254.251.8.237 | {240.116.30.226,254.251.8.237,255.226.130.53} 24 255.226.130.53 | {240.116.30.226,254.251.8.237,255.226.130.53} 25(16 rows) 26 27select a4, 28 array_agg(a4) over (order by a4 range between ip4 '16.0.0.0' preceding and ip4 '16.0.0.0' following) 29 from ipaddrs 30 where a4 is not null; 31 a4 | array_agg 32-----------------+------------------------------------------------------------- 33 12.174.29.15 | {12.174.29.15} 34 33.8.16.211 | {33.8.16.211} 35 55.224.125.146 | {55.224.125.146} 36 73.239.169.71 | {73.239.169.71,76.178.38.194} 37 76.178.38.194 | {73.239.169.71,76.178.38.194} 38 96.76.124.246 | {96.76.124.246,104.175.11.72} 39 104.175.11.72 | {96.76.124.246,104.175.11.72} 40 163.145.90.183 | {163.145.90.183} 41 189.85.58.60 | {189.85.58.60,195.58.214.186,203.156.110.93} 42 195.58.214.186 | {189.85.58.60,195.58.214.186,203.156.110.93} 43 203.156.110.93 | {189.85.58.60,195.58.214.186,203.156.110.93} 44 223.213.219.214 | {223.213.219.214,235.64.97.205} 45 235.64.97.205 | {223.213.219.214,235.64.97.205,240.116.30.226} 46 240.116.30.226 | {235.64.97.205,240.116.30.226,254.251.8.237,255.226.130.53} 47 254.251.8.237 | {240.116.30.226,254.251.8.237,255.226.130.53} 48 255.226.130.53 | {240.116.30.226,254.251.8.237,255.226.130.53} 49(16 rows) 50 51select a4, 52 array_agg(a4) over (order by a4 range between -3 preceding and -3 following) 53 from ipaddrs 54 where a4 is not null; 55 a4 | array_agg 56-----------------+------------------------------------------------------------- 57 12.174.29.15 | {12.174.29.15} 58 33.8.16.211 | {33.8.16.211,55.224.125.146} 59 55.224.125.146 | {33.8.16.211,55.224.125.146} 60 73.239.169.71 | {73.239.169.71,76.178.38.194} 61 76.178.38.194 | {73.239.169.71,76.178.38.194} 62 96.76.124.246 | {96.76.124.246,104.175.11.72} 63 104.175.11.72 | {96.76.124.246,104.175.11.72} 64 163.145.90.183 | {163.145.90.183,189.85.58.60} 65 189.85.58.60 | {163.145.90.183,189.85.58.60} 66 195.58.214.186 | {195.58.214.186,203.156.110.93,223.213.219.214} 67 203.156.110.93 | {195.58.214.186,203.156.110.93,223.213.219.214} 68 223.213.219.214 | {195.58.214.186,203.156.110.93,223.213.219.214} 69 235.64.97.205 | {235.64.97.205,240.116.30.226,254.251.8.237,255.226.130.53} 70 240.116.30.226 | {235.64.97.205,240.116.30.226,254.251.8.237,255.226.130.53} 71 254.251.8.237 | {235.64.97.205,240.116.30.226,254.251.8.237,255.226.130.53} 72 255.226.130.53 | {235.64.97.205,240.116.30.226,254.251.8.237,255.226.130.53} 73(16 rows) 74 75select a6, 76 array_agg(a6) over (order by a6 range between -10 preceding and -10 following) 77 from ipaddrs 78 where a6 is not null; 79 a6 | array_agg 80-----------------------------------------+-------------------------------------------------------------------------------------------------------------------------- 81 73:3c34:57a:2a84:b1df:81b0:eb40:61cd | {73:3c34:57a:2a84:b1df:81b0:eb40:61cd} 82 b6:8ebc:c326:48a6:5615:a65e:e87a:25d7 | {b6:8ebc:c326:48a6:5615:a65e:e87a:25d7} 83 166:b8ea:1fc5:8913:17ea:d6a0:ac2b:90e1 | {166:b8ea:1fc5:8913:17ea:d6a0:ac2b:90e1} 84 227:b768:d43b:773d:6168:5133:867c:13f2 | {227:b768:d43b:773d:6168:5133:867c:13f2} 85 453:2d:fbd3:191:95c6:3751:eb62:e90 | {453:2d:fbd3:191:95c6:3751:eb62:e90} 86 4a6:7a28:b05b:f9b4:cc5b:9c4c:eefe:3e06 | {4a6:7a28:b05b:f9b4:cc5b:9c4c:eefe:3e06} 87 550:fe90:bd02:a3ed:35a2:3254:e280:cd20 | {550:fe90:bd02:a3ed:35a2:3254:e280:cd20} 88 75d:e701:5702:6087:a69a:1a2d:376e:4eb | {75d:e701:5702:6087:a69a:1a2d:376e:4eb} 89 7e1:a608:dadd:684d:679e:698b:4db:c8c2 | {7e1:a608:dadd:684d:679e:698b:4db:c8c2} 90 9ec:8fec:9a0e:3f2a:66e2:9b5c:498a:1090 | {9ec:8fec:9a0e:3f2a:66e2:9b5c:498a:1090} 91 a4b:4e55:7510:69b9:ba73:6550:eaa7:f16e | {a4b:4e55:7510:69b9:ba73:6550:eaa7:f16e} 92 bdb:15d3:fbaf:4bf6:194e:4d0d:4cb2:26c2 | {bdb:15d3:fbaf:4bf6:194e:4d0d:4cb2:26c2} 93 cc6:3030:8e26:ed4a:ae48:4496:63c3:94d0 | {cc6:3030:8e26:ed4a:ae48:4496:63c3:94d0,ce0:f080:aff1:6780:4951:55a7:4c23:f108} 94 ce0:f080:aff1:6780:4951:55a7:4c23:f108 | {cc6:3030:8e26:ed4a:ae48:4496:63c3:94d0,ce0:f080:aff1:6780:4951:55a7:4c23:f108} 95 d6b:f94a:4040:ba81:2347:d486:ac79:96f7 | {d6b:f94a:4040:ba81:2347:d486:ac79:96f7} 96 d9a:933a:3c47:801a:51d4:5a48:13bb:f59b | {d9a:933a:3c47:801a:51d4:5a48:13bb:f59b} 97 ded:898a:e003:6046:72e6:5584:1012:62cc | {ded:898a:e003:6046:72e6:5584:1012:62cc} 98 f47:6def:21e4:4620:3bc:9abc:8abd:aba2 | {f47:6def:21e4:4620:3bc:9abc:8abd:aba2} 99 1009:d4ec:fe15:7946:eff2:6827:349e:6f0c | {1009:d4ec:fe15:7946:eff2:6827:349e:6f0c} 100 10a5:994f:884d:9f98:4920:408d:1504:561d | {10a5:994f:884d:9f98:4920:408d:1504:561d} 101 1378:f0c0:8ca:c76d:f062:4b7a:2573:5710 | {1378:f0c0:8ca:c76d:f062:4b7a:2573:5710} 102 1395:59cf:33f6:988:1cf8:5ef3:3c2f:64dc | {1395:59cf:33f6:988:1cf8:5ef3:3c2f:64dc} 103 13d9:9e39:ff4a:875f:82a0:77bc:1559:cf8d | {13d9:9e39:ff4a:875f:82a0:77bc:1559:cf8d,13fb:9738:a243:f879:730:2b72:783f:75e9} 104 13fb:9738:a243:f879:730:2b72:783f:75e9 | {13d9:9e39:ff4a:875f:82a0:77bc:1559:cf8d,13fb:9738:a243:f879:730:2b72:783f:75e9} 105 14fd:6de8:95f:fade:a20c:81d3:98da:c560 | {14fd:6de8:95f:fade:a20c:81d3:98da:c560} 106 1520:c2bc:8426:2927:9e12:5f90:f4b0:30e6 | {1520:c2bc:8426:2927:9e12:5f90:f4b0:30e6} 107 163a:503e:a2d7:c0d8:f5ee:657e:7f23:ea52 | {163a:503e:a2d7:c0d8:f5ee:657e:7f23:ea52} 108 1685:dcd3:5113:5d84:2e64:d9e2:a602:aab7 | {1685:dcd3:5113:5d84:2e64:d9e2:a602:aab7} 109 1839:8d68:ec5f:a4e7:711d:124e:150b:cddf | {1839:8d68:ec5f:a4e7:711d:124e:150b:cddf} 110 1863:bf8e:aef5:1ac4:f85a:6683:8f7c:d191 | {1863:bf8e:aef5:1ac4:f85a:6683:8f7c:d191} 111 18e8:f97:72d0:5444:c94:99fe:4a9e:f657 | {18e8:f97:72d0:5444:c94:99fe:4a9e:f657,18eb:378d:f12f:6114:34d2:ce03:e0d8:cffc} 112 18eb:378d:f12f:6114:34d2:ce03:e0d8:cffc | {18e8:f97:72d0:5444:c94:99fe:4a9e:f657,18eb:378d:f12f:6114:34d2:ce03:e0d8:cffc} 113 1962:ff9f:665f:ba25:d25a:f530:a391:5ab7 | {1962:ff9f:665f:ba25:d25a:f530:a391:5ab7} 114 1b96:6d23:348f:a5f2:1869:1cd5:eff5:d09a | {1b96:6d23:348f:a5f2:1869:1cd5:eff5:d09a} 115 1bc2:3fea:257c:553e:eb87:d8c7:ef94:4c9 | {1bc2:3fea:257c:553e:eb87:d8c7:ef94:4c9,1be9:3504:b341:17a8:10ec:e646:b0:433} 116 1be9:3504:b341:17a8:10ec:e646:b0:433 | {1bc2:3fea:257c:553e:eb87:d8c7:ef94:4c9,1be9:3504:b341:17a8:10ec:e646:b0:433} 117 1c3e:17b6:1bfd:77ea:2185:9748:38d:ac80 | {1c3e:17b6:1bfd:77ea:2185:9748:38d:ac80} 118 1c90:5c1b:9431:11ea:f6dd:bb7c:c57f:6cc6 | {1c90:5c1b:9431:11ea:f6dd:bb7c:c57f:6cc6} 119 1cc5:18d6:116d:d727:86b:9655:f44d:4fb7 | {1cc5:18d6:116d:d727:86b:9655:f44d:4fb7} 120 1dbf:c6d8:ce1a:e3e3:c9a2:8458:3674:f6b | {1dbf:c6d8:ce1a:e3e3:c9a2:8458:3674:f6b} 121 1f38:cd00:b368:80e5:7579:df75:3c50:b21b | {1f38:cd00:b368:80e5:7579:df75:3c50:b21b} 122 204f:510d:e7e9:9c02:9576:48b1:bfb7:468 | {204f:510d:e7e9:9c02:9576:48b1:bfb7:468} 123 21ef:74a4:2571:e430:47b1:a582:9723:9b14 | {21ef:74a4:2571:e430:47b1:a582:9723:9b14} 124 2394:74d2:f34d:3801:3a23:f022:dc17:2cf | {2394:74d2:f34d:3801:3a23:f022:dc17:2cf} 125 23fd:5d2:8e6a:628:b4e:3ff2:d386:d2b0 | {23fd:5d2:8e6a:628:b4e:3ff2:d386:d2b0} 126 2408:f23d:d1ac:746d:2c8f:3dd6:7ed0:5507 | {2408:f23d:d1ac:746d:2c8f:3dd6:7ed0:5507} 127 25d9:67f6:f409:c774:60ad:9d6a:b95b:4ad2 | {25d9:67f6:f409:c774:60ad:9d6a:b95b:4ad2,25f0:72d:e515:bc9b:f9a2:6061:b18b:758e} 128 25f0:72d:e515:bc9b:f9a2:6061:b18b:758e | {25d9:67f6:f409:c774:60ad:9d6a:b95b:4ad2,25f0:72d:e515:bc9b:f9a2:6061:b18b:758e} 129 2689:eae5:4101:f97c:628a:58fa:f0b5:159 | {2689:eae5:4101:f97c:628a:58fa:f0b5:159,26a3:7ac5:3ce2:cb2d:994d:8f10:82b6:419d,26ad:4d5b:192c:f85a:71db:38be:c6ca:19de} 130 26a3:7ac5:3ce2:cb2d:994d:8f10:82b6:419d | {2689:eae5:4101:f97c:628a:58fa:f0b5:159,26a3:7ac5:3ce2:cb2d:994d:8f10:82b6:419d,26ad:4d5b:192c:f85a:71db:38be:c6ca:19de} 131 26ad:4d5b:192c:f85a:71db:38be:c6ca:19de | {2689:eae5:4101:f97c:628a:58fa:f0b5:159,26a3:7ac5:3ce2:cb2d:994d:8f10:82b6:419d,26ad:4d5b:192c:f85a:71db:38be:c6ca:19de} 132 28a6:2032:8a38:de85:f6f3:47bd:5124:7dc8 | {28a6:2032:8a38:de85:f6f3:47bd:5124:7dc8} 133 28e7:4441:e0a4:bf30:4cf4:edb0:638d:ad72 | {28e7:4441:e0a4:bf30:4cf4:edb0:638d:ad72} 134 29a4:a288:457e:57a9:bbb3:2a76:b117:b1e8 | {29a4:a288:457e:57a9:bbb3:2a76:b117:b1e8,29b2:d3c1:26c4:86b6:19b5:14dc:ab2d:bc67} 135 29b2:d3c1:26c4:86b6:19b5:14dc:ab2d:bc67 | {29a4:a288:457e:57a9:bbb3:2a76:b117:b1e8,29b2:d3c1:26c4:86b6:19b5:14dc:ab2d:bc67} 136 2a8a:5b38:cbdd:5d1c:e1b0:d627:f31f:285a | {2a8a:5b38:cbdd:5d1c:e1b0:d627:f31f:285a} 137 2b47:da0e:8c52:cc33:afaa:f85f:f143:88c6 | {2b47:da0e:8c52:cc33:afaa:f85f:f143:88c6} 138 2ee9:6428:5482:9721:9e51:ca52:ba3:99eb | {2ee9:6428:5482:9721:9e51:ca52:ba3:99eb} 139 2f48:4d4b:443c:6de6:9cbe:9766:fd5:c88b | {2f48:4d4b:443c:6de6:9cbe:9766:fd5:c88b} 140 2ff2:b6b6:ffd1:dc5f:fc2:defe:fd16:a414 | {2ff2:b6b6:ffd1:dc5f:fc2:defe:fd16:a414} 141 3138:9022:3412:4cfb:fc2a:729a:651c:40f9 | {3138:9022:3412:4cfb:fc2a:729a:651c:40f9} 142 318f:1162:8f48:3397:cb9a:f54e:f1e8:d05d | {318f:1162:8f48:3397:cb9a:f54e:f1e8:d05d} 143 32ca:6639:c07e:c474:fa11:c83:2886:516c | {32ca:6639:c07e:c474:fa11:c83:2886:516c} 144 35f1:eb03:921c:f397:cd41:9201:f7e0:dfad | {35f1:eb03:921c:f397:cd41:9201:f7e0:dfad,35f3:d696:b49e:1a25:375:5e28:15c9:96ce} 145 35f3:d696:b49e:1a25:375:5e28:15c9:96ce | {35f1:eb03:921c:f397:cd41:9201:f7e0:dfad,35f3:d696:b49e:1a25:375:5e28:15c9:96ce} 146 3902:4c48:d872:37bd:2e53:678d:3a0a:3cf6 | {3902:4c48:d872:37bd:2e53:678d:3a0a:3cf6,390b:b7a:6606:af43:233b:2e27:8336:5b2e} 147 390b:b7a:6606:af43:233b:2e27:8336:5b2e | {3902:4c48:d872:37bd:2e53:678d:3a0a:3cf6,390b:b7a:6606:af43:233b:2e27:8336:5b2e} 148 39ec:d6ba:1f45:64d0:f4d2:3f0f:78e:a404 | {39ec:d6ba:1f45:64d0:f4d2:3f0f:78e:a404} 149 3af7:2de9:30a7:818d:9715:3eaf:d8f7:2583 | {3af7:2de9:30a7:818d:9715:3eaf:d8f7:2583} 150 3b13:802b:cfd:15ef:bab3:f337:8b00:5744 | {3b13:802b:cfd:15ef:bab3:f337:8b00:5744} 151 3bc9:de98:c700:5aa:d993:223e:dad:1949 | {3bc9:de98:c700:5aa:d993:223e:dad:1949} 152 4068:6d06:7463:589:3262:86d1:f1f1:f088 | {4068:6d06:7463:589:3262:86d1:f1f1:f088} 153 4111:e35f:ce3:c4de:dc4e:8764:8cd:1686 | {4111:e35f:ce3:c4de:dc4e:8764:8cd:1686,4131:d8b6:82af:797d:25fd:7bd4:b94d:ce34} 154 4131:d8b6:82af:797d:25fd:7bd4:b94d:ce34 | {4111:e35f:ce3:c4de:dc4e:8764:8cd:1686,4131:d8b6:82af:797d:25fd:7bd4:b94d:ce34} 155 42e2:d76f:c784:7a61:67c1:b931:6f49:32c5 | {42e2:d76f:c784:7a61:67c1:b931:6f49:32c5} 156 4430:8b98:82c8:3d6c:dbd6:579e:c3fc:ec9d | {4430:8b98:82c8:3d6c:dbd6:579e:c3fc:ec9d,4439:44b6:c04:de6a:c0af:cf35:d9f3:f8ee} 157 4439:44b6:c04:de6a:c0af:cf35:d9f3:f8ee | {4430:8b98:82c8:3d6c:dbd6:579e:c3fc:ec9d,4439:44b6:c04:de6a:c0af:cf35:d9f3:f8ee} 158 450b:493b:a4d7:f0d3:6fe4:6da0:b550:f4ca | {450b:493b:a4d7:f0d3:6fe4:6da0:b550:f4ca} 159 454c:20ee:35b9:b48b:a59f:e4bc:7b76:f228 | {454c:20ee:35b9:b48b:a59f:e4bc:7b76:f228,454e:bfa0:ed21:4983:7572:22c9:413d:d4db} 160 454e:bfa0:ed21:4983:7572:22c9:413d:d4db | {454c:20ee:35b9:b48b:a59f:e4bc:7b76:f228,454e:bfa0:ed21:4983:7572:22c9:413d:d4db} 161 4620:c642:9985:6a1f:6c66:50c0:2108:10d3 | {4620:c642:9985:6a1f:6c66:50c0:2108:10d3} 162 4647:353:5292:8bef:e5b5:c13a:1176:deef | {4647:353:5292:8bef:e5b5:c13a:1176:deef} 163 4bd6:2076:745e:acbe:c511:3786:60be:b51d | {4bd6:2076:745e:acbe:c511:3786:60be:b51d} 164 4d6a:edd6:a446:6d89:e2a3:ab27:79ec:e148 | {4d6a:edd6:a446:6d89:e2a3:ab27:79ec:e148} 165 4ee3:bfaa:5f22:2c05:573e:e87c:a6c2:81e0 | {4ee3:bfaa:5f22:2c05:573e:e87c:a6c2:81e0} 166 53ad:31ab:bc5e:c535:bc7c:5762:c11e:fcec | {53ad:31ab:bc5e:c535:bc7c:5762:c11e:fcec} 167 53d6:7f94:6b26:59cb:9c16:2aa:9722:b8ef | {53d6:7f94:6b26:59cb:9c16:2aa:9722:b8ef} 168 5412:a54d:dbd8:8448:4728:5fb0:ec6f:4381 | {5412:a54d:dbd8:8448:4728:5fb0:ec6f:4381} 169 5466:93e3:8343:3686:394:778:79ac:772 | {5466:93e3:8343:3686:394:778:79ac:772} 170 54b6:4a85:c1a5:89b0:b7ff:5306:32be:d30f | {54b6:4a85:c1a5:89b0:b7ff:5306:32be:d30f} 171 5637:5e57:c050:53fe:e182:697:ab46:21cc | {5637:5e57:c050:53fe:e182:697:ab46:21cc} 172 56fd:83db:3ff7:b0b:7d5:8378:a486:f20 | {56fd:83db:3ff7:b0b:7d5:8378:a486:f20} 173 5721:3c79:a6ff:c8d8:5e3:c785:808:e40 | {5721:3c79:a6ff:c8d8:5e3:c785:808:e40} 174 5889:8398:cb90:8df:b3d6:3f5c:72cb:cd64 | {5889:8398:cb90:8df:b3d6:3f5c:72cb:cd64} 175 599b:9e01:9a22:aebf:a731:ce57:fefb:8ed | {599b:9e01:9a22:aebf:a731:ce57:fefb:8ed} 176 5a0b:33a9:3407:aa9c:f1c7:a538:2f25:bf14 | {5a0b:33a9:3407:aa9c:f1c7:a538:2f25:bf14,5a3f:b436:785f:32a4:8c86:13f8:e682:8b6a} 177 5a3f:b436:785f:32a4:8c86:13f8:e682:8b6a | {5a0b:33a9:3407:aa9c:f1c7:a538:2f25:bf14,5a3f:b436:785f:32a4:8c86:13f8:e682:8b6a} 178 5d63:9613:7b87:5c26:5c80:bbd3:14b5:1e63 | {5d63:9613:7b87:5c26:5c80:bbd3:14b5:1e63} 179 5e52:9aa9:8f83:2a67:5959:720d:f6ba:5d42 | {5e52:9aa9:8f83:2a67:5959:720d:f6ba:5d42} 180 5ee2:4fab:1073:b2f5:61c1:eea6:302f:685 | {5ee2:4fab:1073:b2f5:61c1:eea6:302f:685} 181 5fa8:25bb:15e8:5b35:758c:2044:d194:1962 | {5fa8:25bb:15e8:5b35:758c:2044:d194:1962} 182 61f2:afe0:d1af:18e9:5d40:7a4d:f112:2d09 | {61f2:afe0:d1af:18e9:5d40:7a4d:f112:2d09} 183 6251:ab4b:3b37:d71f:6b5f:1b2d:bd55:3a3c | {6251:ab4b:3b37:d71f:6b5f:1b2d:bd55:3a3c} 184 62b8:256d:637a:82bf:3b69:420:eea5:300b | {62b8:256d:637a:82bf:3b69:420:eea5:300b} 185 62db:eab9:a54e:3cea:46f3:b7c2:cb9c:6e5d | {62db:eab9:a54e:3cea:46f3:b7c2:cb9c:6e5d} 186 6656:e87d:865c:3237:8d42:ff01:a82b:f308 | {6656:e87d:865c:3237:8d42:ff01:a82b:f308} 187 6a93:ccd3:5002:233f:1c5f:400e:601c:75a | {6a93:ccd3:5002:233f:1c5f:400e:601c:75a} 188 6b0c:4791:ccea:c286:437e:d268:87ef:b6ad | {6b0c:4791:ccea:c286:437e:d268:87ef:b6ad} 189 6e1b:5e9c:f623:6134:7754:fdac:323a:dba2 | {6e1b:5e9c:f623:6134:7754:fdac:323a:dba2} 190 6e81:4a6a:d383:140d:8416:c09b:af3b:5b45 | {6e81:4a6a:d383:140d:8416:c09b:af3b:5b45,6e9d:66e:27c5:c7c4:aefe:ecfc:6568:ccf} 191 6e9d:66e:27c5:c7c4:aefe:ecfc:6568:ccf | {6e81:4a6a:d383:140d:8416:c09b:af3b:5b45,6e9d:66e:27c5:c7c4:aefe:ecfc:6568:ccf} 192 6ff2:94f5:5755:164d:1301:28ce:8a04:eac0 | {6ff2:94f5:5755:164d:1301:28ce:8a04:eac0} 193 72c4:104f:960c:baf1:8ef7:60d2:c58:8b03 | {72c4:104f:960c:baf1:8ef7:60d2:c58:8b03} 194 7341:d21f:e576:f226:f690:a99c:6b55:9933 | {7341:d21f:e576:f226:f690:a99c:6b55:9933} 195 739b:8093:31c6:a42f:a604:d5cb:1350:2d2f | {739b:8093:31c6:a42f:a604:d5cb:1350:2d2f} 196 7524:1f76:fe52:991e:667b:a302:dfd5:dbd6 | {7524:1f76:fe52:991e:667b:a302:dfd5:dbd6} 197 7608:50bf:a29a:6805:c760:9ae3:1216:8e4a | {7608:50bf:a29a:6805:c760:9ae3:1216:8e4a} 198 78c8:1cde:4b95:55d8:b211:a95d:37e0:7d92 | {78c8:1cde:4b95:55d8:b211:a95d:37e0:7d92} 199 7924:9e5b:2c7:3920:9c9f:bfb6:369d:fa4f | {7924:9e5b:2c7:3920:9c9f:bfb6:369d:fa4f} 200 798f:ea8:61f6:5d79:1656:d8d8:9b6e:57f0 | {798f:ea8:61f6:5d79:1656:d8d8:9b6e:57f0} 201 79c9:d301:92cd:c774:abbb:2f7d:92c3:3ccd | {79c9:d301:92cd:c774:abbb:2f7d:92c3:3ccd,79eb:6133:5173:8f43:87d4:cb1d:906b:e8c9} 202 79eb:6133:5173:8f43:87d4:cb1d:906b:e8c9 | {79c9:d301:92cd:c774:abbb:2f7d:92c3:3ccd,79eb:6133:5173:8f43:87d4:cb1d:906b:e8c9} 203 7cba:a835:f850:6409:dba7:1300:f2b8:1db3 | {7cba:a835:f850:6409:dba7:1300:f2b8:1db3} 204 7cdf:1ed8:690e:9e54:6f39:613e:f187:8ef2 | {7cdf:1ed8:690e:9e54:6f39:613e:f187:8ef2} 205 7dcc:877b:8e07:aeb4:d891:581e:c10c:af54 | {7dcc:877b:8e07:aeb4:d891:581e:c10c:af54} 206 7e1f:eb76:49c9:39f8:deb9:c447:b40c:a13d | {7e1f:eb76:49c9:39f8:deb9:c447:b40c:a13d} 207 7ec8:2b00:5994:7f0f:d765:5e16:c274:5645 | {7ec8:2b00:5994:7f0f:d765:5e16:c274:5645} 208 7f3d:d8ea:7a7c:8700:5b81:412f:c33a:d6ba | {7f3d:d8ea:7a7c:8700:5b81:412f:c33a:d6ba} 209 7fa2:dbdb:e889:e24b:4d30:962e:89f3:676f | {7fa2:dbdb:e889:e24b:4d30:962e:89f3:676f} 210 8119:1220:b888:3d8a:1250:ce77:b2b9:bdcd | {8119:1220:b888:3d8a:1250:ce77:b2b9:bdcd,8129:3e9c:70ff:1df1:f26f:86aa:c7ba:8245} 211 8129:3e9c:70ff:1df1:f26f:86aa:c7ba:8245 | {8119:1220:b888:3d8a:1250:ce77:b2b9:bdcd,8129:3e9c:70ff:1df1:f26f:86aa:c7ba:8245} 212 8172:4609:d700:5bd2:24a2:8f78:f1cc:c1a0 | {8172:4609:d700:5bd2:24a2:8f78:f1cc:c1a0} 213 8241:abe3:7537:de41:ef5a:7d2a:9e57:833b | {8241:abe3:7537:de41:ef5a:7d2a:9e57:833b} 214 828e:fa1d:9bb1:ad4c:4874:9da8:40bf:25b5 | {828e:fa1d:9bb1:ad4c:4874:9da8:40bf:25b5,8298:9399:271f:a3fe:270c:21cf:7c34:7340} 215 8298:9399:271f:a3fe:270c:21cf:7c34:7340 | {828e:fa1d:9bb1:ad4c:4874:9da8:40bf:25b5,8298:9399:271f:a3fe:270c:21cf:7c34:7340} 216 82ed:ac69:4ea7:5301:b005:3e17:f541:4fbc | {82ed:ac69:4ea7:5301:b005:3e17:f541:4fbc} 217 8357:a24:2f6e:f909:3853:899a:68af:b48 | {8357:a24:2f6e:f909:3853:899a:68af:b48} 218 8474:e00a:5b49:6e2a:5074:ecd5:cece:7dad | {8474:e00a:5b49:6e2a:5074:ecd5:cece:7dad} 219 84fe:7351:7b39:349e:1bb7:e333:daec:141a | {84fe:7351:7b39:349e:1bb7:e333:daec:141a} 220 8586:595:7bdd:359b:2fd9:1ffa:49ef:a947 | {8586:595:7bdd:359b:2fd9:1ffa:49ef:a947} 221 86fa:3a3:6a26:5ce3:fd8d:6267:b3c:4bf0 | {86fa:3a3:6a26:5ce3:fd8d:6267:b3c:4bf0} 222 874b:a74e:e292:c13:cf80:778c:35b4:d37c | {874b:a74e:e292:c13:cf80:778c:35b4:d37c} 223 88bb:cf40:1f19:c897:f001:2d56:8f4f:ac68 | {88bb:cf40:1f19:c897:f001:2d56:8f4f:ac68} 224 8909:5e3:cff9:483c:1fb7:2ee2:ab05:222a | {8909:5e3:cff9:483c:1fb7:2ee2:ab05:222a,890b:aa44:e2b1:ff61:eb7a:c4df:5a25:2eaf} 225 890b:aa44:e2b1:ff61:eb7a:c4df:5a25:2eaf | {8909:5e3:cff9:483c:1fb7:2ee2:ab05:222a,890b:aa44:e2b1:ff61:eb7a:c4df:5a25:2eaf} 226 8a1f:674e:63cd:f241:8f53:aec9:d8db:8e5c | {8a1f:674e:63cd:f241:8f53:aec9:d8db:8e5c} 227 8b0c:b103:3302:90bb:bac:809e:9c7d:3569 | {8b0c:b103:3302:90bb:bac:809e:9c7d:3569} 228 8b61:6b31:d02c:87d3:22cf:f01c:c045:b822 | {8b61:6b31:d02c:87d3:22cf:f01c:c045:b822} 229 8b87:864a:8e83:6783:c552:cb07:8e96:c0e5 | {8b87:864a:8e83:6783:c552:cb07:8e96:c0e5} 230 8c86:2c19:c38d:626b:b5a4:e0cb:bbaf:476b | {8c86:2c19:c38d:626b:b5a4:e0cb:bbaf:476b} 231 8ec2:3493:ad95:cb7e:ae1c:8c2c:6a34:eccb | {8ec2:3493:ad95:cb7e:ae1c:8c2c:6a34:eccb,8ecc:14db:7aba:bbde:f2a7:c4bc:7a1e:c8c1} 232 8ecc:14db:7aba:bbde:f2a7:c4bc:7a1e:c8c1 | {8ec2:3493:ad95:cb7e:ae1c:8c2c:6a34:eccb,8ecc:14db:7aba:bbde:f2a7:c4bc:7a1e:c8c1} 233 8f7a:5e8b:f526:a8ba:8c6f:3cae:7b7e:1a5 | {8f7a:5e8b:f526:a8ba:8c6f:3cae:7b7e:1a5} 234 8fa1:e604:6ad4:c318:ba8f:eaec:76be:ad4b | {8fa1:e604:6ad4:c318:ba8f:eaec:76be:ad4b,8fac:3b7e:463d:1b38:2f59:6fdf:3bef:4aaf} 235 8fac:3b7e:463d:1b38:2f59:6fdf:3bef:4aaf | {8fa1:e604:6ad4:c318:ba8f:eaec:76be:ad4b,8fac:3b7e:463d:1b38:2f59:6fdf:3bef:4aaf} 236 933f:d5b:d307:c3e0:5e0:b947:1cb5:6928 | {933f:d5b:d307:c3e0:5e0:b947:1cb5:6928} 237 9520:88f9:9498:8a73:ac7a:dc77:4495:3dfc | {9520:88f9:9498:8a73:ac7a:dc77:4495:3dfc} 238 9631:3557:7591:6ade:1882:6dad:8413:c3b3 | {9631:3557:7591:6ade:1882:6dad:8413:c3b3} 239 977b:de6f:3ef9:3cad:fb02:fb07:458c:e88e | {977b:de6f:3ef9:3cad:fb02:fb07:458c:e88e} 240 982a:e6d8:49bc:49a7:80b:4417:45f7:4fb7 | {982a:e6d8:49bc:49a7:80b:4417:45f7:4fb7} 241 9943:4095:cf6c:bf1d:f1b4:7883:f929:a315 | {9943:4095:cf6c:bf1d:f1b4:7883:f929:a315} 242 99b7:bba0:206c:6042:6778:2f3b:9a:6393 | {99b7:bba0:206c:6042:6778:2f3b:9a:6393} 243 9b3d:56d7:b18e:21b9:7448:3cea:2ec:77f8 | {9b3d:56d7:b18e:21b9:7448:3cea:2ec:77f8} 244 9c51:8c1b:a051:a87e:c65a:cc8:a38e:4953 | {9c51:8c1b:a051:a87e:c65a:cc8:a38e:4953} 245 9d35:9c4f:517d:2391:f59c:af03:1681:6d9b | {9d35:9c4f:517d:2391:f59c:af03:1681:6d9b} 246 9da1:e3ce:660a:cde4:7576:554:55cc:38ad | {9da1:e3ce:660a:cde4:7576:554:55cc:38ad} 247 9ee9:65bd:81d2:b2c6:c3c4:b36b:16a2:fc9e | {9ee9:65bd:81d2:b2c6:c3c4:b36b:16a2:fc9e} 248 a0d3:f0b5:7a50:2d3e:923e:3832:76c0:b15d | {a0d3:f0b5:7a50:2d3e:923e:3832:76c0:b15d} 249 a252:248:a123:3287:680f:a67c:2fcd:b2a0 | {a252:248:a123:3287:680f:a67c:2fcd:b2a0} 250 a300:d184:bf44:e8f1:4a80:723c:909:f178 | {a300:d184:bf44:e8f1:4a80:723c:909:f178,a335:f1a7:be5c:b341:5325:e8d3:2631:74ae} 251 a335:f1a7:be5c:b341:5325:e8d3:2631:74ae | {a300:d184:bf44:e8f1:4a80:723c:909:f178,a335:f1a7:be5c:b341:5325:e8d3:2631:74ae} 252 a42d:662e:1816:1fe3:a392:9190:7d4e:f418 | {a42d:662e:1816:1fe3:a392:9190:7d4e:f418} 253 a52f:f73a:413e:a43a:5000:cd8f:ef1f:3603 | {a52f:f73a:413e:a43a:5000:cd8f:ef1f:3603} 254 a75b:c708:8e74:b252:f8e8:7269:c214:dc07 | {a75b:c708:8e74:b252:f8e8:7269:c214:dc07} 255 a87b:8920:6e0:9c1b:92a8:3a1e:f074:1ee2 | {a87b:8920:6e0:9c1b:92a8:3a1e:f074:1ee2} 256 a884:9796:ca7c:ec37:9cb4:4158:ce4c:ced5 | {a884:9796:ca7c:ec37:9cb4:4158:ce4c:ced5} 257 a9e9:74a5:864a:dfeb:a5f0:4424:d294:95a1 | {a9e9:74a5:864a:dfeb:a5f0:4424:d294:95a1} 258 ac4c:23a6:9c5f:8a2a:ccfc:ea69:48cd:dffc | {ac4c:23a6:9c5f:8a2a:ccfc:ea69:48cd:dffc,ac71:fd2c:4352:c28a:2f4b:3cd1:4d6f:927b} 259 ac71:fd2c:4352:c28a:2f4b:3cd1:4d6f:927b | {ac4c:23a6:9c5f:8a2a:ccfc:ea69:48cd:dffc,ac71:fd2c:4352:c28a:2f4b:3cd1:4d6f:927b} 260 ad73:992f:b3d8:31f7:306d:a418:fdcf:3e60 | {ad73:992f:b3d8:31f7:306d:a418:fdcf:3e60} 261 ae64:d6a3:11d7:b6bc:aa3:60c6:b16f:4305 | {ae64:d6a3:11d7:b6bc:aa3:60c6:b16f:4305} 262 af5a:6507:2c50:f0a8:b211:fc0d:425e:bd47 | {af5a:6507:2c50:f0a8:b211:fc0d:425e:bd47} 263 afeb:a771:735e:1a18:9297:e9f4:2e53:c5e1 | {afeb:a771:735e:1a18:9297:e9f4:2e53:c5e1} 264 b105:5518:a963:9a0a:d10d:b42b:dfd1:96a2 | {b105:5518:a963:9a0a:d10d:b42b:dfd1:96a2,b113:66f:e222:f032:7161:1f27:b080:2111} 265 b113:66f:e222:f032:7161:1f27:b080:2111 | {b105:5518:a963:9a0a:d10d:b42b:dfd1:96a2,b113:66f:e222:f032:7161:1f27:b080:2111} 266 b218:c6f2:4929:7d70:8b4d:5458:fc85:d0fc | {b218:c6f2:4929:7d70:8b4d:5458:fc85:d0fc,b237:dac3:62d7:725e:d772:c88c:af71:cec5} 267 b237:dac3:62d7:725e:d772:c88c:af71:cec5 | {b218:c6f2:4929:7d70:8b4d:5458:fc85:d0fc,b237:dac3:62d7:725e:d772:c88c:af71:cec5} 268 b310:3d72:ea86:6ee:45fc:d57f:4a7a:bb43 | {b310:3d72:ea86:6ee:45fc:d57f:4a7a:bb43} 269 b3da:187b:cc2e:3c78:e060:aab6:63cb:1780 | {b3da:187b:cc2e:3c78:e060:aab6:63cb:1780} 270 b408:9874:22a3:9f56:35f:cfd1:b00:ddac | {b408:9874:22a3:9f56:35f:cfd1:b00:ddac} 271 b48c:eccb:32f4:2b4:e2ee:e787:a16f:8647 | {b48c:eccb:32f4:2b4:e2ee:e787:a16f:8647} 272 b8ef:17e2:febe:431d:9d8c:88c6:6604:a678 | {b8ef:17e2:febe:431d:9d8c:88c6:6604:a678} 273 ba0d:d2d4:b5e3:573f:98f4:98e:aac1:47fa | {ba0d:d2d4:b5e3:573f:98f4:98e:aac1:47fa} 274 baf9:2948:a8a1:8865:912a:839f:45e8:78d3 | {baf9:2948:a8a1:8865:912a:839f:45e8:78d3} 275 bb1b:6a20:8513:14e4:5fc6:c0e9:17df:9c0 | {bb1b:6a20:8513:14e4:5fc6:c0e9:17df:9c0} 276 bc1d:d3ba:50da:14d3:f496:6847:3b91:2830 | {bc1d:d3ba:50da:14d3:f496:6847:3b91:2830} 277 bc52:8171:9377:d593:1c0a:75e4:e2d:5e1a | {bc52:8171:9377:d593:1c0a:75e4:e2d:5e1a} 278 bd6f:44b9:45d3:529f:84c7:612:b25c:aaf8 | {bd6f:44b9:45d3:529f:84c7:612:b25c:aaf8} 279 bdc5:94f5:8249:7120:8132:ca25:d3fc:c394 | {bdc5:94f5:8249:7120:8132:ca25:d3fc:c394} 280 c0fc:f3ee:3707:19dc:62c1:5c9a:df3d:1b58 | {c0fc:f3ee:3707:19dc:62c1:5c9a:df3d:1b58} 281 c2e3:4cea:30dd:cb39:c5a0:86e7:8b05:3f7 | {c2e3:4cea:30dd:cb39:c5a0:86e7:8b05:3f7} 282 c36f:f4fd:4853:a07c:c25d:349f:3af4:3432 | {c36f:f4fd:4853:a07c:c25d:349f:3af4:3432} 283 c504:481e:2756:3ca2:f0c:a26a:4e64:7804 | {c504:481e:2756:3ca2:f0c:a26a:4e64:7804} 284 c6ff:8d3c:d2d1:ee46:65ca:27f9:cc07:8e6d | {c6ff:8d3c:d2d1:ee46:65ca:27f9:cc07:8e6d} 285 c8c0:5117:331a:f029:8d24:6775:fe7d:5976 | {c8c0:5117:331a:f029:8d24:6775:fe7d:5976} 286 c963:10d0:1586:d1d4:79bc:d7af:5486:43e5 | {c963:10d0:1586:d1d4:79bc:d7af:5486:43e5} 287 c99c:bd43:6161:d17d:2fdd:ab61:922:ba62 | {c99c:bd43:6161:d17d:2fdd:ab61:922:ba62} 288 cb2f:b8da:ba34:1c5c:4839:710a:f75b:bdd0 | {cb2f:b8da:ba34:1c5c:4839:710a:f75b:bdd0} 289 cb70:a0cc:6919:db7f:8fc8:cb69:6fcc:5f5b | {cb70:a0cc:6919:db7f:8fc8:cb69:6fcc:5f5b} 290 cc17:3814:d80f:41a1:1309:35d3:ea0a:d31e | {cc17:3814:d80f:41a1:1309:35d3:ea0a:d31e} 291 ce47:e5eb:41f3:23af:6209:5ade:82ce:3b00 | {ce47:e5eb:41f3:23af:6209:5ade:82ce:3b00} 292 cfb9:d37e:2427:af8d:b728:8f90:f54c:9141 | {cfb9:d37e:2427:af8d:b728:8f90:f54c:9141} 293 d066:f25b:e8a5:4ae6:4c99:2a98:8cb7:2530 | {d066:f25b:e8a5:4ae6:4c99:2a98:8cb7:2530} 294 d105:1597:c912:51c7:e5b6:f628:cae:1d0f | {d105:1597:c912:51c7:e5b6:f628:cae:1d0f} 295 d2de:7aa1:975:e510:dfa1:2a3:89bc:eedb | {d2de:7aa1:975:e510:dfa1:2a3:89bc:eedb} 296 d33e:e847:b4c6:d5ca:f75:216b:342c:3d04 | {d33e:e847:b4c6:d5ca:f75:216b:342c:3d04} 297 d395:c008:43a4:48d9:15a7:ce74:6546:c56b | {d395:c008:43a4:48d9:15a7:ce74:6546:c56b} 298 d452:6fb9:f2b0:d387:80ca:47d5:330f:577 | {d452:6fb9:f2b0:d387:80ca:47d5:330f:577} 299 d524:77db:2a21:e05b:68c4:575c:f04b:b0b7 | {d524:77db:2a21:e05b:68c4:575c:f04b:b0b7} 300 d6d1:e96c:cd2f:8396:23f2:c96d:9376:54cb | {d6d1:e96c:cd2f:8396:23f2:c96d:9376:54cb} 301 d76b:986d:d38b:252a:e6a2:254e:b0f7:db24 | {d76b:986d:d38b:252a:e6a2:254e:b0f7:db24} 302 d9f3:2018:6aa2:7ee4:64be:e2d:c32c:2d15 | {d9f3:2018:6aa2:7ee4:64be:e2d:c32c:2d15} 303 da3e:c57c:ccc8:edbf:f66e:85a5:e252:a3a4 | {da3e:c57c:ccc8:edbf:f66e:85a5:e252:a3a4} 304 da52:3791:27b8:f773:7a59:1414:6d76:bd8a | {da52:3791:27b8:f773:7a59:1414:6d76:bd8a} 305 da97:ecc5:bf17:1bb2:5710:f753:604c:7cf6 | {da97:ecc5:bf17:1bb2:5710:f753:604c:7cf6} 306 dc61:8bf4:4b82:90a4:8af0:6a43:a917:14ee | {dc61:8bf4:4b82:90a4:8af0:6a43:a917:14ee} 307 dd3b:ad95:1e55:a555:daae:8218:99d7:7bce | {dd3b:ad95:1e55:a555:daae:8218:99d7:7bce} 308 defd:c729:62b4:8959:6ad1:7b1f:5835:8ffb | {defd:c729:62b4:8959:6ad1:7b1f:5835:8ffb} 309 dfe2:c097:49ae:1d60:e3db:26c1:bb5d:c4e0 | {dfe2:c097:49ae:1d60:e3db:26c1:bb5d:c4e0} 310 e11c:4f21:dd57:c814:af4e:3f55:4adf:f1a0 | {e11c:4f21:dd57:c814:af4e:3f55:4adf:f1a0} 311 e199:2ea0:f3b4:3a31:5d15:dfc9:68cd:c948 | {e199:2ea0:f3b4:3a31:5d15:dfc9:68cd:c948} 312 e57b:76e8:3f3a:3020:a22a:38b7:9c02:5db4 | {e57b:76e8:3f3a:3020:a22a:38b7:9c02:5db4} 313 e6da:dc3c:a935:a718:4744:a216:84bd:cfa9 | {e6da:dc3c:a935:a718:4744:a216:84bd:cfa9} 314 e7a7:adbe:d6de:41ba:a34f:d10b:46a7:a4cf | {e7a7:adbe:d6de:41ba:a34f:d10b:46a7:a4cf} 315 e86d:edb4:8702:1774:c97d:cbee:394:a083 | {e86d:edb4:8702:1774:c97d:cbee:394:a083} 316 e97f:c466:f346:cf67:23e4:bd36:72be:af44 | {e97f:c466:f346:cf67:23e4:bd36:72be:af44} 317 ec36:7c6d:3077:267e:399a:d47:55a4:218a | {ec36:7c6d:3077:267e:399a:d47:55a4:218a} 318 ee1d:a078:25d4:94e3:9a89:707d:6fae:7573 | {ee1d:a078:25d4:94e3:9a89:707d:6fae:7573,ee34:9ba:9281:593c:ab74:57fa:e439:e0f3} 319 ee34:9ba:9281:593c:ab74:57fa:e439:e0f3 | {ee1d:a078:25d4:94e3:9a89:707d:6fae:7573,ee34:9ba:9281:593c:ab74:57fa:e439:e0f3} 320 ee76:e9ac:dd2:66c1:380:5f1e:1c4d:2867 | {ee76:e9ac:dd2:66c1:380:5f1e:1c4d:2867} 321 eea0:9aef:71b:3cfd:e2ad:864c:41b8:938c | {eea0:9aef:71b:3cfd:e2ad:864c:41b8:938c} 322 ef15:3aa9:3c5b:b993:5209:a130:2d37:3a64 | {ef15:3aa9:3c5b:b993:5209:a130:2d37:3a64} 323 ef9a:b980:e9:d50a:d867:8a88:2cae:8aa1 | {ef9a:b980:e9:d50a:d867:8a88:2cae:8aa1} 324 effb:1a90:1dd5:e52c:1d7f:c716:3744:170a | {effb:1a90:1dd5:e52c:1d7f:c716:3744:170a} 325 f0a1:e730:68b9:2e1c:649a:5450:a256:4665 | {f0a1:e730:68b9:2e1c:649a:5450:a256:4665} 326 f3df:f155:d5c6:d664:c93c:13fa:9d77:6bf2 | {f3df:f155:d5c6:d664:c93c:13fa:9d77:6bf2} 327 f499:668f:fbb8:f0dc:8e41:d43b:c025:26a | {f499:668f:fbb8:f0dc:8e41:d43b:c025:26a} 328 f57a:a3dc:3b11:f28a:8b25:8d5b:ec2f:c729 | {f57a:a3dc:3b11:f28a:8b25:8d5b:ec2f:c729} 329 f7b8:dfc:496c:9718:ae3c:5c3e:b98a:4c5f | {f7b8:dfc:496c:9718:ae3c:5c3e:b98a:4c5f} 330 fa78:68ce:4fb1:d54c:2007:1820:ffe2:8235 | {fa78:68ce:4fb1:d54c:2007:1820:ffe2:8235} 331 fbb6:2d70:42eb:55ab:6235:6867:2b3:8d47 | {fbb6:2d70:42eb:55ab:6235:6867:2b3:8d47} 332 fcea:f739:a97d:cefc:49c4:b3c3:c7b4:99d6 | {fcea:f739:a97d:cefc:49c4:b3c3:c7b4:99d6} 333 fda3:3e75:37c5:c1f:912b:5e32:6aa9:aeb2 | {fda3:3e75:37c5:c1f:912b:5e32:6aa9:aeb2} 334 ff3d:7d5b:b0fe:c30:9e6c:23e0:7b5:e9de | {ff3d:7d5b:b0fe:c30:9e6c:23e0:7b5:e9de} 335 ff4a:cbbf:695a:9e46:f27c:e1be:861f:9e7 | {ff4a:cbbf:695a:9e46:f27c:e1be:861f:9e7,ff6b:af36:5fc2:93d9:ebf3:3c62:a19f:307f} 336 ff6b:af36:5fc2:93d9:ebf3:3c62:a19f:307f | {ff4a:cbbf:695a:9e46:f27c:e1be:861f:9e7,ff6b:af36:5fc2:93d9:ebf3:3c62:a19f:307f} 337(256 rows) 338 339select a6, 340 array_agg(a6) over (order by a6 range between ip6 '0010::' preceding and ip6 '0010::' following) 341 from ipaddrs 342 where a6 is not null; 343 a6 | array_agg 344-----------------------------------------+----------------------------------------------------------------------------------- 345 73:3c34:57a:2a84:b1df:81b0:eb40:61cd | {73:3c34:57a:2a84:b1df:81b0:eb40:61cd} 346 b6:8ebc:c326:48a6:5615:a65e:e87a:25d7 | {b6:8ebc:c326:48a6:5615:a65e:e87a:25d7} 347 166:b8ea:1fc5:8913:17ea:d6a0:ac2b:90e1 | {166:b8ea:1fc5:8913:17ea:d6a0:ac2b:90e1} 348 227:b768:d43b:773d:6168:5133:867c:13f2 | {227:b768:d43b:773d:6168:5133:867c:13f2} 349 453:2d:fbd3:191:95c6:3751:eb62:e90 | {453:2d:fbd3:191:95c6:3751:eb62:e90} 350 4a6:7a28:b05b:f9b4:cc5b:9c4c:eefe:3e06 | {4a6:7a28:b05b:f9b4:cc5b:9c4c:eefe:3e06} 351 550:fe90:bd02:a3ed:35a2:3254:e280:cd20 | {550:fe90:bd02:a3ed:35a2:3254:e280:cd20} 352 75d:e701:5702:6087:a69a:1a2d:376e:4eb | {75d:e701:5702:6087:a69a:1a2d:376e:4eb} 353 7e1:a608:dadd:684d:679e:698b:4db:c8c2 | {7e1:a608:dadd:684d:679e:698b:4db:c8c2} 354 9ec:8fec:9a0e:3f2a:66e2:9b5c:498a:1090 | {9ec:8fec:9a0e:3f2a:66e2:9b5c:498a:1090} 355 a4b:4e55:7510:69b9:ba73:6550:eaa7:f16e | {a4b:4e55:7510:69b9:ba73:6550:eaa7:f16e} 356 bdb:15d3:fbaf:4bf6:194e:4d0d:4cb2:26c2 | {bdb:15d3:fbaf:4bf6:194e:4d0d:4cb2:26c2} 357 cc6:3030:8e26:ed4a:ae48:4496:63c3:94d0 | {cc6:3030:8e26:ed4a:ae48:4496:63c3:94d0} 358 ce0:f080:aff1:6780:4951:55a7:4c23:f108 | {ce0:f080:aff1:6780:4951:55a7:4c23:f108} 359 d6b:f94a:4040:ba81:2347:d486:ac79:96f7 | {d6b:f94a:4040:ba81:2347:d486:ac79:96f7} 360 d9a:933a:3c47:801a:51d4:5a48:13bb:f59b | {d9a:933a:3c47:801a:51d4:5a48:13bb:f59b} 361 ded:898a:e003:6046:72e6:5584:1012:62cc | {ded:898a:e003:6046:72e6:5584:1012:62cc} 362 f47:6def:21e4:4620:3bc:9abc:8abd:aba2 | {f47:6def:21e4:4620:3bc:9abc:8abd:aba2} 363 1009:d4ec:fe15:7946:eff2:6827:349e:6f0c | {1009:d4ec:fe15:7946:eff2:6827:349e:6f0c} 364 10a5:994f:884d:9f98:4920:408d:1504:561d | {10a5:994f:884d:9f98:4920:408d:1504:561d} 365 1378:f0c0:8ca:c76d:f062:4b7a:2573:5710 | {1378:f0c0:8ca:c76d:f062:4b7a:2573:5710} 366 1395:59cf:33f6:988:1cf8:5ef3:3c2f:64dc | {1395:59cf:33f6:988:1cf8:5ef3:3c2f:64dc} 367 13d9:9e39:ff4a:875f:82a0:77bc:1559:cf8d | {13d9:9e39:ff4a:875f:82a0:77bc:1559:cf8d} 368 13fb:9738:a243:f879:730:2b72:783f:75e9 | {13fb:9738:a243:f879:730:2b72:783f:75e9} 369 14fd:6de8:95f:fade:a20c:81d3:98da:c560 | {14fd:6de8:95f:fade:a20c:81d3:98da:c560} 370 1520:c2bc:8426:2927:9e12:5f90:f4b0:30e6 | {1520:c2bc:8426:2927:9e12:5f90:f4b0:30e6} 371 163a:503e:a2d7:c0d8:f5ee:657e:7f23:ea52 | {163a:503e:a2d7:c0d8:f5ee:657e:7f23:ea52} 372 1685:dcd3:5113:5d84:2e64:d9e2:a602:aab7 | {1685:dcd3:5113:5d84:2e64:d9e2:a602:aab7} 373 1839:8d68:ec5f:a4e7:711d:124e:150b:cddf | {1839:8d68:ec5f:a4e7:711d:124e:150b:cddf} 374 1863:bf8e:aef5:1ac4:f85a:6683:8f7c:d191 | {1863:bf8e:aef5:1ac4:f85a:6683:8f7c:d191} 375 18e8:f97:72d0:5444:c94:99fe:4a9e:f657 | {18e8:f97:72d0:5444:c94:99fe:4a9e:f657,18eb:378d:f12f:6114:34d2:ce03:e0d8:cffc} 376 18eb:378d:f12f:6114:34d2:ce03:e0d8:cffc | {18e8:f97:72d0:5444:c94:99fe:4a9e:f657,18eb:378d:f12f:6114:34d2:ce03:e0d8:cffc} 377 1962:ff9f:665f:ba25:d25a:f530:a391:5ab7 | {1962:ff9f:665f:ba25:d25a:f530:a391:5ab7} 378 1b96:6d23:348f:a5f2:1869:1cd5:eff5:d09a | {1b96:6d23:348f:a5f2:1869:1cd5:eff5:d09a} 379 1bc2:3fea:257c:553e:eb87:d8c7:ef94:4c9 | {1bc2:3fea:257c:553e:eb87:d8c7:ef94:4c9} 380 1be9:3504:b341:17a8:10ec:e646:b0:433 | {1be9:3504:b341:17a8:10ec:e646:b0:433} 381 1c3e:17b6:1bfd:77ea:2185:9748:38d:ac80 | {1c3e:17b6:1bfd:77ea:2185:9748:38d:ac80} 382 1c90:5c1b:9431:11ea:f6dd:bb7c:c57f:6cc6 | {1c90:5c1b:9431:11ea:f6dd:bb7c:c57f:6cc6} 383 1cc5:18d6:116d:d727:86b:9655:f44d:4fb7 | {1cc5:18d6:116d:d727:86b:9655:f44d:4fb7} 384 1dbf:c6d8:ce1a:e3e3:c9a2:8458:3674:f6b | {1dbf:c6d8:ce1a:e3e3:c9a2:8458:3674:f6b} 385 1f38:cd00:b368:80e5:7579:df75:3c50:b21b | {1f38:cd00:b368:80e5:7579:df75:3c50:b21b} 386 204f:510d:e7e9:9c02:9576:48b1:bfb7:468 | {204f:510d:e7e9:9c02:9576:48b1:bfb7:468} 387 21ef:74a4:2571:e430:47b1:a582:9723:9b14 | {21ef:74a4:2571:e430:47b1:a582:9723:9b14} 388 2394:74d2:f34d:3801:3a23:f022:dc17:2cf | {2394:74d2:f34d:3801:3a23:f022:dc17:2cf} 389 23fd:5d2:8e6a:628:b4e:3ff2:d386:d2b0 | {23fd:5d2:8e6a:628:b4e:3ff2:d386:d2b0,2408:f23d:d1ac:746d:2c8f:3dd6:7ed0:5507} 390 2408:f23d:d1ac:746d:2c8f:3dd6:7ed0:5507 | {23fd:5d2:8e6a:628:b4e:3ff2:d386:d2b0,2408:f23d:d1ac:746d:2c8f:3dd6:7ed0:5507} 391 25d9:67f6:f409:c774:60ad:9d6a:b95b:4ad2 | {25d9:67f6:f409:c774:60ad:9d6a:b95b:4ad2} 392 25f0:72d:e515:bc9b:f9a2:6061:b18b:758e | {25f0:72d:e515:bc9b:f9a2:6061:b18b:758e} 393 2689:eae5:4101:f97c:628a:58fa:f0b5:159 | {2689:eae5:4101:f97c:628a:58fa:f0b5:159} 394 26a3:7ac5:3ce2:cb2d:994d:8f10:82b6:419d | {26a3:7ac5:3ce2:cb2d:994d:8f10:82b6:419d,26ad:4d5b:192c:f85a:71db:38be:c6ca:19de} 395 26ad:4d5b:192c:f85a:71db:38be:c6ca:19de | {26a3:7ac5:3ce2:cb2d:994d:8f10:82b6:419d,26ad:4d5b:192c:f85a:71db:38be:c6ca:19de} 396 28a6:2032:8a38:de85:f6f3:47bd:5124:7dc8 | {28a6:2032:8a38:de85:f6f3:47bd:5124:7dc8} 397 28e7:4441:e0a4:bf30:4cf4:edb0:638d:ad72 | {28e7:4441:e0a4:bf30:4cf4:edb0:638d:ad72} 398 29a4:a288:457e:57a9:bbb3:2a76:b117:b1e8 | {29a4:a288:457e:57a9:bbb3:2a76:b117:b1e8,29b2:d3c1:26c4:86b6:19b5:14dc:ab2d:bc67} 399 29b2:d3c1:26c4:86b6:19b5:14dc:ab2d:bc67 | {29a4:a288:457e:57a9:bbb3:2a76:b117:b1e8,29b2:d3c1:26c4:86b6:19b5:14dc:ab2d:bc67} 400 2a8a:5b38:cbdd:5d1c:e1b0:d627:f31f:285a | {2a8a:5b38:cbdd:5d1c:e1b0:d627:f31f:285a} 401 2b47:da0e:8c52:cc33:afaa:f85f:f143:88c6 | {2b47:da0e:8c52:cc33:afaa:f85f:f143:88c6} 402 2ee9:6428:5482:9721:9e51:ca52:ba3:99eb | {2ee9:6428:5482:9721:9e51:ca52:ba3:99eb} 403 2f48:4d4b:443c:6de6:9cbe:9766:fd5:c88b | {2f48:4d4b:443c:6de6:9cbe:9766:fd5:c88b} 404 2ff2:b6b6:ffd1:dc5f:fc2:defe:fd16:a414 | {2ff2:b6b6:ffd1:dc5f:fc2:defe:fd16:a414} 405 3138:9022:3412:4cfb:fc2a:729a:651c:40f9 | {3138:9022:3412:4cfb:fc2a:729a:651c:40f9} 406 318f:1162:8f48:3397:cb9a:f54e:f1e8:d05d | {318f:1162:8f48:3397:cb9a:f54e:f1e8:d05d} 407 32ca:6639:c07e:c474:fa11:c83:2886:516c | {32ca:6639:c07e:c474:fa11:c83:2886:516c} 408 35f1:eb03:921c:f397:cd41:9201:f7e0:dfad | {35f1:eb03:921c:f397:cd41:9201:f7e0:dfad,35f3:d696:b49e:1a25:375:5e28:15c9:96ce} 409 35f3:d696:b49e:1a25:375:5e28:15c9:96ce | {35f1:eb03:921c:f397:cd41:9201:f7e0:dfad,35f3:d696:b49e:1a25:375:5e28:15c9:96ce} 410 3902:4c48:d872:37bd:2e53:678d:3a0a:3cf6 | {3902:4c48:d872:37bd:2e53:678d:3a0a:3cf6,390b:b7a:6606:af43:233b:2e27:8336:5b2e} 411 390b:b7a:6606:af43:233b:2e27:8336:5b2e | {3902:4c48:d872:37bd:2e53:678d:3a0a:3cf6,390b:b7a:6606:af43:233b:2e27:8336:5b2e} 412 39ec:d6ba:1f45:64d0:f4d2:3f0f:78e:a404 | {39ec:d6ba:1f45:64d0:f4d2:3f0f:78e:a404} 413 3af7:2de9:30a7:818d:9715:3eaf:d8f7:2583 | {3af7:2de9:30a7:818d:9715:3eaf:d8f7:2583} 414 3b13:802b:cfd:15ef:bab3:f337:8b00:5744 | {3b13:802b:cfd:15ef:bab3:f337:8b00:5744} 415 3bc9:de98:c700:5aa:d993:223e:dad:1949 | {3bc9:de98:c700:5aa:d993:223e:dad:1949} 416 4068:6d06:7463:589:3262:86d1:f1f1:f088 | {4068:6d06:7463:589:3262:86d1:f1f1:f088} 417 4111:e35f:ce3:c4de:dc4e:8764:8cd:1686 | {4111:e35f:ce3:c4de:dc4e:8764:8cd:1686} 418 4131:d8b6:82af:797d:25fd:7bd4:b94d:ce34 | {4131:d8b6:82af:797d:25fd:7bd4:b94d:ce34} 419 42e2:d76f:c784:7a61:67c1:b931:6f49:32c5 | {42e2:d76f:c784:7a61:67c1:b931:6f49:32c5} 420 4430:8b98:82c8:3d6c:dbd6:579e:c3fc:ec9d | {4430:8b98:82c8:3d6c:dbd6:579e:c3fc:ec9d,4439:44b6:c04:de6a:c0af:cf35:d9f3:f8ee} 421 4439:44b6:c04:de6a:c0af:cf35:d9f3:f8ee | {4430:8b98:82c8:3d6c:dbd6:579e:c3fc:ec9d,4439:44b6:c04:de6a:c0af:cf35:d9f3:f8ee} 422 450b:493b:a4d7:f0d3:6fe4:6da0:b550:f4ca | {450b:493b:a4d7:f0d3:6fe4:6da0:b550:f4ca} 423 454c:20ee:35b9:b48b:a59f:e4bc:7b76:f228 | {454c:20ee:35b9:b48b:a59f:e4bc:7b76:f228,454e:bfa0:ed21:4983:7572:22c9:413d:d4db} 424 454e:bfa0:ed21:4983:7572:22c9:413d:d4db | {454c:20ee:35b9:b48b:a59f:e4bc:7b76:f228,454e:bfa0:ed21:4983:7572:22c9:413d:d4db} 425 4620:c642:9985:6a1f:6c66:50c0:2108:10d3 | {4620:c642:9985:6a1f:6c66:50c0:2108:10d3} 426 4647:353:5292:8bef:e5b5:c13a:1176:deef | {4647:353:5292:8bef:e5b5:c13a:1176:deef} 427 4bd6:2076:745e:acbe:c511:3786:60be:b51d | {4bd6:2076:745e:acbe:c511:3786:60be:b51d} 428 4d6a:edd6:a446:6d89:e2a3:ab27:79ec:e148 | {4d6a:edd6:a446:6d89:e2a3:ab27:79ec:e148} 429 4ee3:bfaa:5f22:2c05:573e:e87c:a6c2:81e0 | {4ee3:bfaa:5f22:2c05:573e:e87c:a6c2:81e0} 430 53ad:31ab:bc5e:c535:bc7c:5762:c11e:fcec | {53ad:31ab:bc5e:c535:bc7c:5762:c11e:fcec} 431 53d6:7f94:6b26:59cb:9c16:2aa:9722:b8ef | {53d6:7f94:6b26:59cb:9c16:2aa:9722:b8ef} 432 5412:a54d:dbd8:8448:4728:5fb0:ec6f:4381 | {5412:a54d:dbd8:8448:4728:5fb0:ec6f:4381} 433 5466:93e3:8343:3686:394:778:79ac:772 | {5466:93e3:8343:3686:394:778:79ac:772} 434 54b6:4a85:c1a5:89b0:b7ff:5306:32be:d30f | {54b6:4a85:c1a5:89b0:b7ff:5306:32be:d30f} 435 5637:5e57:c050:53fe:e182:697:ab46:21cc | {5637:5e57:c050:53fe:e182:697:ab46:21cc} 436 56fd:83db:3ff7:b0b:7d5:8378:a486:f20 | {56fd:83db:3ff7:b0b:7d5:8378:a486:f20} 437 5721:3c79:a6ff:c8d8:5e3:c785:808:e40 | {5721:3c79:a6ff:c8d8:5e3:c785:808:e40} 438 5889:8398:cb90:8df:b3d6:3f5c:72cb:cd64 | {5889:8398:cb90:8df:b3d6:3f5c:72cb:cd64} 439 599b:9e01:9a22:aebf:a731:ce57:fefb:8ed | {599b:9e01:9a22:aebf:a731:ce57:fefb:8ed} 440 5a0b:33a9:3407:aa9c:f1c7:a538:2f25:bf14 | {5a0b:33a9:3407:aa9c:f1c7:a538:2f25:bf14} 441 5a3f:b436:785f:32a4:8c86:13f8:e682:8b6a | {5a3f:b436:785f:32a4:8c86:13f8:e682:8b6a} 442 5d63:9613:7b87:5c26:5c80:bbd3:14b5:1e63 | {5d63:9613:7b87:5c26:5c80:bbd3:14b5:1e63} 443 5e52:9aa9:8f83:2a67:5959:720d:f6ba:5d42 | {5e52:9aa9:8f83:2a67:5959:720d:f6ba:5d42} 444 5ee2:4fab:1073:b2f5:61c1:eea6:302f:685 | {5ee2:4fab:1073:b2f5:61c1:eea6:302f:685} 445 5fa8:25bb:15e8:5b35:758c:2044:d194:1962 | {5fa8:25bb:15e8:5b35:758c:2044:d194:1962} 446 61f2:afe0:d1af:18e9:5d40:7a4d:f112:2d09 | {61f2:afe0:d1af:18e9:5d40:7a4d:f112:2d09} 447 6251:ab4b:3b37:d71f:6b5f:1b2d:bd55:3a3c | {6251:ab4b:3b37:d71f:6b5f:1b2d:bd55:3a3c} 448 62b8:256d:637a:82bf:3b69:420:eea5:300b | {62b8:256d:637a:82bf:3b69:420:eea5:300b} 449 62db:eab9:a54e:3cea:46f3:b7c2:cb9c:6e5d | {62db:eab9:a54e:3cea:46f3:b7c2:cb9c:6e5d} 450 6656:e87d:865c:3237:8d42:ff01:a82b:f308 | {6656:e87d:865c:3237:8d42:ff01:a82b:f308} 451 6a93:ccd3:5002:233f:1c5f:400e:601c:75a | {6a93:ccd3:5002:233f:1c5f:400e:601c:75a} 452 6b0c:4791:ccea:c286:437e:d268:87ef:b6ad | {6b0c:4791:ccea:c286:437e:d268:87ef:b6ad} 453 6e1b:5e9c:f623:6134:7754:fdac:323a:dba2 | {6e1b:5e9c:f623:6134:7754:fdac:323a:dba2} 454 6e81:4a6a:d383:140d:8416:c09b:af3b:5b45 | {6e81:4a6a:d383:140d:8416:c09b:af3b:5b45} 455 6e9d:66e:27c5:c7c4:aefe:ecfc:6568:ccf | {6e9d:66e:27c5:c7c4:aefe:ecfc:6568:ccf} 456 6ff2:94f5:5755:164d:1301:28ce:8a04:eac0 | {6ff2:94f5:5755:164d:1301:28ce:8a04:eac0} 457 72c4:104f:960c:baf1:8ef7:60d2:c58:8b03 | {72c4:104f:960c:baf1:8ef7:60d2:c58:8b03} 458 7341:d21f:e576:f226:f690:a99c:6b55:9933 | {7341:d21f:e576:f226:f690:a99c:6b55:9933} 459 739b:8093:31c6:a42f:a604:d5cb:1350:2d2f | {739b:8093:31c6:a42f:a604:d5cb:1350:2d2f} 460 7524:1f76:fe52:991e:667b:a302:dfd5:dbd6 | {7524:1f76:fe52:991e:667b:a302:dfd5:dbd6} 461 7608:50bf:a29a:6805:c760:9ae3:1216:8e4a | {7608:50bf:a29a:6805:c760:9ae3:1216:8e4a} 462 78c8:1cde:4b95:55d8:b211:a95d:37e0:7d92 | {78c8:1cde:4b95:55d8:b211:a95d:37e0:7d92} 463 7924:9e5b:2c7:3920:9c9f:bfb6:369d:fa4f | {7924:9e5b:2c7:3920:9c9f:bfb6:369d:fa4f} 464 798f:ea8:61f6:5d79:1656:d8d8:9b6e:57f0 | {798f:ea8:61f6:5d79:1656:d8d8:9b6e:57f0} 465 79c9:d301:92cd:c774:abbb:2f7d:92c3:3ccd | {79c9:d301:92cd:c774:abbb:2f7d:92c3:3ccd} 466 79eb:6133:5173:8f43:87d4:cb1d:906b:e8c9 | {79eb:6133:5173:8f43:87d4:cb1d:906b:e8c9} 467 7cba:a835:f850:6409:dba7:1300:f2b8:1db3 | {7cba:a835:f850:6409:dba7:1300:f2b8:1db3} 468 7cdf:1ed8:690e:9e54:6f39:613e:f187:8ef2 | {7cdf:1ed8:690e:9e54:6f39:613e:f187:8ef2} 469 7dcc:877b:8e07:aeb4:d891:581e:c10c:af54 | {7dcc:877b:8e07:aeb4:d891:581e:c10c:af54} 470 7e1f:eb76:49c9:39f8:deb9:c447:b40c:a13d | {7e1f:eb76:49c9:39f8:deb9:c447:b40c:a13d} 471 7ec8:2b00:5994:7f0f:d765:5e16:c274:5645 | {7ec8:2b00:5994:7f0f:d765:5e16:c274:5645} 472 7f3d:d8ea:7a7c:8700:5b81:412f:c33a:d6ba | {7f3d:d8ea:7a7c:8700:5b81:412f:c33a:d6ba} 473 7fa2:dbdb:e889:e24b:4d30:962e:89f3:676f | {7fa2:dbdb:e889:e24b:4d30:962e:89f3:676f} 474 8119:1220:b888:3d8a:1250:ce77:b2b9:bdcd | {8119:1220:b888:3d8a:1250:ce77:b2b9:bdcd} 475 8129:3e9c:70ff:1df1:f26f:86aa:c7ba:8245 | {8129:3e9c:70ff:1df1:f26f:86aa:c7ba:8245} 476 8172:4609:d700:5bd2:24a2:8f78:f1cc:c1a0 | {8172:4609:d700:5bd2:24a2:8f78:f1cc:c1a0} 477 8241:abe3:7537:de41:ef5a:7d2a:9e57:833b | {8241:abe3:7537:de41:ef5a:7d2a:9e57:833b} 478 828e:fa1d:9bb1:ad4c:4874:9da8:40bf:25b5 | {828e:fa1d:9bb1:ad4c:4874:9da8:40bf:25b5,8298:9399:271f:a3fe:270c:21cf:7c34:7340} 479 8298:9399:271f:a3fe:270c:21cf:7c34:7340 | {828e:fa1d:9bb1:ad4c:4874:9da8:40bf:25b5,8298:9399:271f:a3fe:270c:21cf:7c34:7340} 480 82ed:ac69:4ea7:5301:b005:3e17:f541:4fbc | {82ed:ac69:4ea7:5301:b005:3e17:f541:4fbc} 481 8357:a24:2f6e:f909:3853:899a:68af:b48 | {8357:a24:2f6e:f909:3853:899a:68af:b48} 482 8474:e00a:5b49:6e2a:5074:ecd5:cece:7dad | {8474:e00a:5b49:6e2a:5074:ecd5:cece:7dad} 483 84fe:7351:7b39:349e:1bb7:e333:daec:141a | {84fe:7351:7b39:349e:1bb7:e333:daec:141a} 484 8586:595:7bdd:359b:2fd9:1ffa:49ef:a947 | {8586:595:7bdd:359b:2fd9:1ffa:49ef:a947} 485 86fa:3a3:6a26:5ce3:fd8d:6267:b3c:4bf0 | {86fa:3a3:6a26:5ce3:fd8d:6267:b3c:4bf0} 486 874b:a74e:e292:c13:cf80:778c:35b4:d37c | {874b:a74e:e292:c13:cf80:778c:35b4:d37c} 487 88bb:cf40:1f19:c897:f001:2d56:8f4f:ac68 | {88bb:cf40:1f19:c897:f001:2d56:8f4f:ac68} 488 8909:5e3:cff9:483c:1fb7:2ee2:ab05:222a | {8909:5e3:cff9:483c:1fb7:2ee2:ab05:222a,890b:aa44:e2b1:ff61:eb7a:c4df:5a25:2eaf} 489 890b:aa44:e2b1:ff61:eb7a:c4df:5a25:2eaf | {8909:5e3:cff9:483c:1fb7:2ee2:ab05:222a,890b:aa44:e2b1:ff61:eb7a:c4df:5a25:2eaf} 490 8a1f:674e:63cd:f241:8f53:aec9:d8db:8e5c | {8a1f:674e:63cd:f241:8f53:aec9:d8db:8e5c} 491 8b0c:b103:3302:90bb:bac:809e:9c7d:3569 | {8b0c:b103:3302:90bb:bac:809e:9c7d:3569} 492 8b61:6b31:d02c:87d3:22cf:f01c:c045:b822 | {8b61:6b31:d02c:87d3:22cf:f01c:c045:b822} 493 8b87:864a:8e83:6783:c552:cb07:8e96:c0e5 | {8b87:864a:8e83:6783:c552:cb07:8e96:c0e5} 494 8c86:2c19:c38d:626b:b5a4:e0cb:bbaf:476b | {8c86:2c19:c38d:626b:b5a4:e0cb:bbaf:476b} 495 8ec2:3493:ad95:cb7e:ae1c:8c2c:6a34:eccb | {8ec2:3493:ad95:cb7e:ae1c:8c2c:6a34:eccb,8ecc:14db:7aba:bbde:f2a7:c4bc:7a1e:c8c1} 496 8ecc:14db:7aba:bbde:f2a7:c4bc:7a1e:c8c1 | {8ec2:3493:ad95:cb7e:ae1c:8c2c:6a34:eccb,8ecc:14db:7aba:bbde:f2a7:c4bc:7a1e:c8c1} 497 8f7a:5e8b:f526:a8ba:8c6f:3cae:7b7e:1a5 | {8f7a:5e8b:f526:a8ba:8c6f:3cae:7b7e:1a5} 498 8fa1:e604:6ad4:c318:ba8f:eaec:76be:ad4b | {8fa1:e604:6ad4:c318:ba8f:eaec:76be:ad4b,8fac:3b7e:463d:1b38:2f59:6fdf:3bef:4aaf} 499 8fac:3b7e:463d:1b38:2f59:6fdf:3bef:4aaf | {8fa1:e604:6ad4:c318:ba8f:eaec:76be:ad4b,8fac:3b7e:463d:1b38:2f59:6fdf:3bef:4aaf} 500 933f:d5b:d307:c3e0:5e0:b947:1cb5:6928 | {933f:d5b:d307:c3e0:5e0:b947:1cb5:6928} 501 9520:88f9:9498:8a73:ac7a:dc77:4495:3dfc | {9520:88f9:9498:8a73:ac7a:dc77:4495:3dfc} 502 9631:3557:7591:6ade:1882:6dad:8413:c3b3 | {9631:3557:7591:6ade:1882:6dad:8413:c3b3} 503 977b:de6f:3ef9:3cad:fb02:fb07:458c:e88e | {977b:de6f:3ef9:3cad:fb02:fb07:458c:e88e} 504 982a:e6d8:49bc:49a7:80b:4417:45f7:4fb7 | {982a:e6d8:49bc:49a7:80b:4417:45f7:4fb7} 505 9943:4095:cf6c:bf1d:f1b4:7883:f929:a315 | {9943:4095:cf6c:bf1d:f1b4:7883:f929:a315} 506 99b7:bba0:206c:6042:6778:2f3b:9a:6393 | {99b7:bba0:206c:6042:6778:2f3b:9a:6393} 507 9b3d:56d7:b18e:21b9:7448:3cea:2ec:77f8 | {9b3d:56d7:b18e:21b9:7448:3cea:2ec:77f8} 508 9c51:8c1b:a051:a87e:c65a:cc8:a38e:4953 | {9c51:8c1b:a051:a87e:c65a:cc8:a38e:4953} 509 9d35:9c4f:517d:2391:f59c:af03:1681:6d9b | {9d35:9c4f:517d:2391:f59c:af03:1681:6d9b} 510 9da1:e3ce:660a:cde4:7576:554:55cc:38ad | {9da1:e3ce:660a:cde4:7576:554:55cc:38ad} 511 9ee9:65bd:81d2:b2c6:c3c4:b36b:16a2:fc9e | {9ee9:65bd:81d2:b2c6:c3c4:b36b:16a2:fc9e} 512 a0d3:f0b5:7a50:2d3e:923e:3832:76c0:b15d | {a0d3:f0b5:7a50:2d3e:923e:3832:76c0:b15d} 513 a252:248:a123:3287:680f:a67c:2fcd:b2a0 | {a252:248:a123:3287:680f:a67c:2fcd:b2a0} 514 a300:d184:bf44:e8f1:4a80:723c:909:f178 | {a300:d184:bf44:e8f1:4a80:723c:909:f178} 515 a335:f1a7:be5c:b341:5325:e8d3:2631:74ae | {a335:f1a7:be5c:b341:5325:e8d3:2631:74ae} 516 a42d:662e:1816:1fe3:a392:9190:7d4e:f418 | {a42d:662e:1816:1fe3:a392:9190:7d4e:f418} 517 a52f:f73a:413e:a43a:5000:cd8f:ef1f:3603 | {a52f:f73a:413e:a43a:5000:cd8f:ef1f:3603} 518 a75b:c708:8e74:b252:f8e8:7269:c214:dc07 | {a75b:c708:8e74:b252:f8e8:7269:c214:dc07} 519 a87b:8920:6e0:9c1b:92a8:3a1e:f074:1ee2 | {a87b:8920:6e0:9c1b:92a8:3a1e:f074:1ee2,a884:9796:ca7c:ec37:9cb4:4158:ce4c:ced5} 520 a884:9796:ca7c:ec37:9cb4:4158:ce4c:ced5 | {a87b:8920:6e0:9c1b:92a8:3a1e:f074:1ee2,a884:9796:ca7c:ec37:9cb4:4158:ce4c:ced5} 521 a9e9:74a5:864a:dfeb:a5f0:4424:d294:95a1 | {a9e9:74a5:864a:dfeb:a5f0:4424:d294:95a1} 522 ac4c:23a6:9c5f:8a2a:ccfc:ea69:48cd:dffc | {ac4c:23a6:9c5f:8a2a:ccfc:ea69:48cd:dffc} 523 ac71:fd2c:4352:c28a:2f4b:3cd1:4d6f:927b | {ac71:fd2c:4352:c28a:2f4b:3cd1:4d6f:927b} 524 ad73:992f:b3d8:31f7:306d:a418:fdcf:3e60 | {ad73:992f:b3d8:31f7:306d:a418:fdcf:3e60} 525 ae64:d6a3:11d7:b6bc:aa3:60c6:b16f:4305 | {ae64:d6a3:11d7:b6bc:aa3:60c6:b16f:4305} 526 af5a:6507:2c50:f0a8:b211:fc0d:425e:bd47 | {af5a:6507:2c50:f0a8:b211:fc0d:425e:bd47} 527 afeb:a771:735e:1a18:9297:e9f4:2e53:c5e1 | {afeb:a771:735e:1a18:9297:e9f4:2e53:c5e1} 528 b105:5518:a963:9a0a:d10d:b42b:dfd1:96a2 | {b105:5518:a963:9a0a:d10d:b42b:dfd1:96a2,b113:66f:e222:f032:7161:1f27:b080:2111} 529 b113:66f:e222:f032:7161:1f27:b080:2111 | {b105:5518:a963:9a0a:d10d:b42b:dfd1:96a2,b113:66f:e222:f032:7161:1f27:b080:2111} 530 b218:c6f2:4929:7d70:8b4d:5458:fc85:d0fc | {b218:c6f2:4929:7d70:8b4d:5458:fc85:d0fc} 531 b237:dac3:62d7:725e:d772:c88c:af71:cec5 | {b237:dac3:62d7:725e:d772:c88c:af71:cec5} 532 b310:3d72:ea86:6ee:45fc:d57f:4a7a:bb43 | {b310:3d72:ea86:6ee:45fc:d57f:4a7a:bb43} 533 b3da:187b:cc2e:3c78:e060:aab6:63cb:1780 | {b3da:187b:cc2e:3c78:e060:aab6:63cb:1780} 534 b408:9874:22a3:9f56:35f:cfd1:b00:ddac | {b408:9874:22a3:9f56:35f:cfd1:b00:ddac} 535 b48c:eccb:32f4:2b4:e2ee:e787:a16f:8647 | {b48c:eccb:32f4:2b4:e2ee:e787:a16f:8647} 536 b8ef:17e2:febe:431d:9d8c:88c6:6604:a678 | {b8ef:17e2:febe:431d:9d8c:88c6:6604:a678} 537 ba0d:d2d4:b5e3:573f:98f4:98e:aac1:47fa | {ba0d:d2d4:b5e3:573f:98f4:98e:aac1:47fa} 538 baf9:2948:a8a1:8865:912a:839f:45e8:78d3 | {baf9:2948:a8a1:8865:912a:839f:45e8:78d3} 539 bb1b:6a20:8513:14e4:5fc6:c0e9:17df:9c0 | {bb1b:6a20:8513:14e4:5fc6:c0e9:17df:9c0} 540 bc1d:d3ba:50da:14d3:f496:6847:3b91:2830 | {bc1d:d3ba:50da:14d3:f496:6847:3b91:2830} 541 bc52:8171:9377:d593:1c0a:75e4:e2d:5e1a | {bc52:8171:9377:d593:1c0a:75e4:e2d:5e1a} 542 bd6f:44b9:45d3:529f:84c7:612:b25c:aaf8 | {bd6f:44b9:45d3:529f:84c7:612:b25c:aaf8} 543 bdc5:94f5:8249:7120:8132:ca25:d3fc:c394 | {bdc5:94f5:8249:7120:8132:ca25:d3fc:c394} 544 c0fc:f3ee:3707:19dc:62c1:5c9a:df3d:1b58 | {c0fc:f3ee:3707:19dc:62c1:5c9a:df3d:1b58} 545 c2e3:4cea:30dd:cb39:c5a0:86e7:8b05:3f7 | {c2e3:4cea:30dd:cb39:c5a0:86e7:8b05:3f7} 546 c36f:f4fd:4853:a07c:c25d:349f:3af4:3432 | {c36f:f4fd:4853:a07c:c25d:349f:3af4:3432} 547 c504:481e:2756:3ca2:f0c:a26a:4e64:7804 | {c504:481e:2756:3ca2:f0c:a26a:4e64:7804} 548 c6ff:8d3c:d2d1:ee46:65ca:27f9:cc07:8e6d | {c6ff:8d3c:d2d1:ee46:65ca:27f9:cc07:8e6d} 549 c8c0:5117:331a:f029:8d24:6775:fe7d:5976 | {c8c0:5117:331a:f029:8d24:6775:fe7d:5976} 550 c963:10d0:1586:d1d4:79bc:d7af:5486:43e5 | {c963:10d0:1586:d1d4:79bc:d7af:5486:43e5} 551 c99c:bd43:6161:d17d:2fdd:ab61:922:ba62 | {c99c:bd43:6161:d17d:2fdd:ab61:922:ba62} 552 cb2f:b8da:ba34:1c5c:4839:710a:f75b:bdd0 | {cb2f:b8da:ba34:1c5c:4839:710a:f75b:bdd0} 553 cb70:a0cc:6919:db7f:8fc8:cb69:6fcc:5f5b | {cb70:a0cc:6919:db7f:8fc8:cb69:6fcc:5f5b} 554 cc17:3814:d80f:41a1:1309:35d3:ea0a:d31e | {cc17:3814:d80f:41a1:1309:35d3:ea0a:d31e} 555 ce47:e5eb:41f3:23af:6209:5ade:82ce:3b00 | {ce47:e5eb:41f3:23af:6209:5ade:82ce:3b00} 556 cfb9:d37e:2427:af8d:b728:8f90:f54c:9141 | {cfb9:d37e:2427:af8d:b728:8f90:f54c:9141} 557 d066:f25b:e8a5:4ae6:4c99:2a98:8cb7:2530 | {d066:f25b:e8a5:4ae6:4c99:2a98:8cb7:2530} 558 d105:1597:c912:51c7:e5b6:f628:cae:1d0f | {d105:1597:c912:51c7:e5b6:f628:cae:1d0f} 559 d2de:7aa1:975:e510:dfa1:2a3:89bc:eedb | {d2de:7aa1:975:e510:dfa1:2a3:89bc:eedb} 560 d33e:e847:b4c6:d5ca:f75:216b:342c:3d04 | {d33e:e847:b4c6:d5ca:f75:216b:342c:3d04} 561 d395:c008:43a4:48d9:15a7:ce74:6546:c56b | {d395:c008:43a4:48d9:15a7:ce74:6546:c56b} 562 d452:6fb9:f2b0:d387:80ca:47d5:330f:577 | {d452:6fb9:f2b0:d387:80ca:47d5:330f:577} 563 d524:77db:2a21:e05b:68c4:575c:f04b:b0b7 | {d524:77db:2a21:e05b:68c4:575c:f04b:b0b7} 564 d6d1:e96c:cd2f:8396:23f2:c96d:9376:54cb | {d6d1:e96c:cd2f:8396:23f2:c96d:9376:54cb} 565 d76b:986d:d38b:252a:e6a2:254e:b0f7:db24 | {d76b:986d:d38b:252a:e6a2:254e:b0f7:db24} 566 d9f3:2018:6aa2:7ee4:64be:e2d:c32c:2d15 | {d9f3:2018:6aa2:7ee4:64be:e2d:c32c:2d15} 567 da3e:c57c:ccc8:edbf:f66e:85a5:e252:a3a4 | {da3e:c57c:ccc8:edbf:f66e:85a5:e252:a3a4} 568 da52:3791:27b8:f773:7a59:1414:6d76:bd8a | {da52:3791:27b8:f773:7a59:1414:6d76:bd8a} 569 da97:ecc5:bf17:1bb2:5710:f753:604c:7cf6 | {da97:ecc5:bf17:1bb2:5710:f753:604c:7cf6} 570 dc61:8bf4:4b82:90a4:8af0:6a43:a917:14ee | {dc61:8bf4:4b82:90a4:8af0:6a43:a917:14ee} 571 dd3b:ad95:1e55:a555:daae:8218:99d7:7bce | {dd3b:ad95:1e55:a555:daae:8218:99d7:7bce} 572 defd:c729:62b4:8959:6ad1:7b1f:5835:8ffb | {defd:c729:62b4:8959:6ad1:7b1f:5835:8ffb} 573 dfe2:c097:49ae:1d60:e3db:26c1:bb5d:c4e0 | {dfe2:c097:49ae:1d60:e3db:26c1:bb5d:c4e0} 574 e11c:4f21:dd57:c814:af4e:3f55:4adf:f1a0 | {e11c:4f21:dd57:c814:af4e:3f55:4adf:f1a0} 575 e199:2ea0:f3b4:3a31:5d15:dfc9:68cd:c948 | {e199:2ea0:f3b4:3a31:5d15:dfc9:68cd:c948} 576 e57b:76e8:3f3a:3020:a22a:38b7:9c02:5db4 | {e57b:76e8:3f3a:3020:a22a:38b7:9c02:5db4} 577 e6da:dc3c:a935:a718:4744:a216:84bd:cfa9 | {e6da:dc3c:a935:a718:4744:a216:84bd:cfa9} 578 e7a7:adbe:d6de:41ba:a34f:d10b:46a7:a4cf | {e7a7:adbe:d6de:41ba:a34f:d10b:46a7:a4cf} 579 e86d:edb4:8702:1774:c97d:cbee:394:a083 | {e86d:edb4:8702:1774:c97d:cbee:394:a083} 580 e97f:c466:f346:cf67:23e4:bd36:72be:af44 | {e97f:c466:f346:cf67:23e4:bd36:72be:af44} 581 ec36:7c6d:3077:267e:399a:d47:55a4:218a | {ec36:7c6d:3077:267e:399a:d47:55a4:218a} 582 ee1d:a078:25d4:94e3:9a89:707d:6fae:7573 | {ee1d:a078:25d4:94e3:9a89:707d:6fae:7573} 583 ee34:9ba:9281:593c:ab74:57fa:e439:e0f3 | {ee34:9ba:9281:593c:ab74:57fa:e439:e0f3} 584 ee76:e9ac:dd2:66c1:380:5f1e:1c4d:2867 | {ee76:e9ac:dd2:66c1:380:5f1e:1c4d:2867} 585 eea0:9aef:71b:3cfd:e2ad:864c:41b8:938c | {eea0:9aef:71b:3cfd:e2ad:864c:41b8:938c} 586 ef15:3aa9:3c5b:b993:5209:a130:2d37:3a64 | {ef15:3aa9:3c5b:b993:5209:a130:2d37:3a64} 587 ef9a:b980:e9:d50a:d867:8a88:2cae:8aa1 | {ef9a:b980:e9:d50a:d867:8a88:2cae:8aa1} 588 effb:1a90:1dd5:e52c:1d7f:c716:3744:170a | {effb:1a90:1dd5:e52c:1d7f:c716:3744:170a} 589 f0a1:e730:68b9:2e1c:649a:5450:a256:4665 | {f0a1:e730:68b9:2e1c:649a:5450:a256:4665} 590 f3df:f155:d5c6:d664:c93c:13fa:9d77:6bf2 | {f3df:f155:d5c6:d664:c93c:13fa:9d77:6bf2} 591 f499:668f:fbb8:f0dc:8e41:d43b:c025:26a | {f499:668f:fbb8:f0dc:8e41:d43b:c025:26a} 592 f57a:a3dc:3b11:f28a:8b25:8d5b:ec2f:c729 | {f57a:a3dc:3b11:f28a:8b25:8d5b:ec2f:c729} 593 f7b8:dfc:496c:9718:ae3c:5c3e:b98a:4c5f | {f7b8:dfc:496c:9718:ae3c:5c3e:b98a:4c5f} 594 fa78:68ce:4fb1:d54c:2007:1820:ffe2:8235 | {fa78:68ce:4fb1:d54c:2007:1820:ffe2:8235} 595 fbb6:2d70:42eb:55ab:6235:6867:2b3:8d47 | {fbb6:2d70:42eb:55ab:6235:6867:2b3:8d47} 596 fcea:f739:a97d:cefc:49c4:b3c3:c7b4:99d6 | {fcea:f739:a97d:cefc:49c4:b3c3:c7b4:99d6} 597 fda3:3e75:37c5:c1f:912b:5e32:6aa9:aeb2 | {fda3:3e75:37c5:c1f:912b:5e32:6aa9:aeb2} 598 ff3d:7d5b:b0fe:c30:9e6c:23e0:7b5:e9de | {ff3d:7d5b:b0fe:c30:9e6c:23e0:7b5:e9de,ff4a:cbbf:695a:9e46:f27c:e1be:861f:9e7} 599 ff4a:cbbf:695a:9e46:f27c:e1be:861f:9e7 | {ff3d:7d5b:b0fe:c30:9e6c:23e0:7b5:e9de,ff4a:cbbf:695a:9e46:f27c:e1be:861f:9e7} 600 ff6b:af36:5fc2:93d9:ebf3:3c62:a19f:307f | {ff6b:af36:5fc2:93d9:ebf3:3c62:a19f:307f} 601(256 rows) 602 603-- errors 604select a4, 605 array_agg(a4) over (order by a4 range between -33 preceding and -33 following) 606 from ipaddrs 607 where a4 is not null; 608ERROR: invalid preceding or following size in window function 609DETAIL: Offset value -33 is outside the range -32 to 4294967295 610select a6, 611 array_agg(a6) over (order by a6 range between -129 preceding and -129 following) 612 from ipaddrs 613 where a6 is not null; 614ERROR: invalid preceding or following size in window function 615DETAIL: Offset value -129 is outside the range -128 to 2^63-1 616-- end 617