bigfunctions > ip_range2ip_networks

ip_range2ip_networks

Signature

ip_range2ip_networks(first_ip, last_ip)

Description

Convert an IP range into a json list of IP networks in CIDR notation (the list can have only one element)

Examples

EUUSeurope-west1

select bigfunctions.eu.ip_range2ip_networks('1.0.0.0', '1.0.0.255')

select bigfunctions.us.ip_range2ip_networks('1.0.0.0', '1.0.0.255')

select bigfunctions.europe_west1.ip_range2ip_networks('1.0.0.0', '1.0.0.255')

+--------------+
| ip_networks  |
+--------------+
| [1.0.0.0/24] |
+--------------+

EUUSeurope-west1

select bigfunctions.eu.ip_range2ip_networks('192.0.2.1', '192.0.2.15')

select bigfunctions.us.ip_range2ip_networks('192.0.2.1', '192.0.2.15')

select bigfunctions.europe_west1.ip_range2ip_networks('192.0.2.1', '192.0.2.15')

+----------------------------------------------------------+
| ip_networks                                              |
+----------------------------------------------------------+
| [192.0.2.1/32, 192.0.2.2/31, 192.0.2.4/30, 192.0.2.8/29] |
+----------------------------------------------------------+