16 17 187 8 9 10 11 12第一行中的计算-一次只考虑两个矩阵中的四个元素(0表示填充):
(1-8)+(2-9)+(3-10)+(4-(2-9)+(3-10)+(4-11)+(5-12): This replaces 2 in initial matrix.(3-10)+(4-11)+(5-12)+(6-0): This replaces 3 in initial matrix.(4-11)+(5-12)+(6-0)+(0-0): This replac
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 +