title: Postgres Check if IP (inet) is IN a list of IP Ranges
body: <p>I want to check if an IP exists in a range of ranges, eg: <code>SELECT * FROM ip_address WHERE ip IN (&lt;list of ip ranges&gt;)</code></p>
  
  <p><a href="https://www.postgresql.org/docs/10/static/functions-net.html" rel="noreferrer">Postgresql documentation</a> states to use the &lt;&lt; operator to check if an IP is contained within a single IP Range, eg: <code>inet '192.168.1.5' &lt;&lt; inet '192.168.1/24'</code>, but I'm not sure how to use it on a list of ranges without having to construct an OR chain of &lt;&lt;'s.</p>