title: Convert IP address in PostgreSQL to integer?
body: <p>Is there a query that would be able to accomplish this?</p>
  
  <p>For example given an entry '216.55.82.34' ..I would want to split the string by the '.'s, and apply the equation:</p>
  
  <p>IP Number = 16777216*w + 65536*x + 256*y + z 
  where IP Address = w.x.y.z</p>
  
  <p>Would this be possible from just a Query?</p>