# select * from geoipcity where startipnum = '78.33.196.42';
  startipnum  |   endipnum   | country | region |    city     | postalcode | lattitude | longitude | dmacode | areacode |  startip   |   endip    
--------------+--------------+---------+--------+-------------+------------+-----------+-----------+---------+----------+------------+------------
 78.33.196.42 | 78.33.196.63 | GB      | E4     | Chesterford |            |   52.0667 |       0.2 |         |          | 1310835754 | 1310835775
(1 row)