vpc-flow-logs-crosszone-entries.sql

UPDATE "vpc" SET "crosszone" = CASE
	-- Get those values from a list of AWS VPC Subnets:
	WHEN dstaddr::inet << '172.31.16.0/20' AND srcaddr::inet << '172.31.16.0/20'
	THEN 0
	WHEN dstaddr::inet << '172.31.0.0/20' AND srcaddr::inet << '172.31.0.0/20'
	THEN 0
	ELSE 1
END, "external" = CASE
	-- This is a combined CIDR of all the subnets. If you can't simplify
	-- into a single condition, add more cases.
	WHEN dstaddr::inet << '172.31.0.0/16' AND srcaddr::inet << '172.31.0.0/16'
	THEN 0
	ELSE 1
;