我想从100.64得到一系列IP地址。到100.127..。5) 100.128.221.557) 100.64.102.254 1. 2nd part of ip should be from 64 to127 range 3. 4th part of ip should be from 0to 255 range
正则表达式应该选择以下ip</em
ip_assigned INET; ip_assigned := (COALESCE((SELECT ip FROM ips WHERE id = inp_id),a LEFT JOIN LATERAL (SELECT * FROM ips b WHERE a.ip < b.ip ORDER BY b.ip ASC LIMIT 1) AS q ON trueWHERE q.ip <> (a.ip +