Klipp rundt trondheim

query.txt

delete from table where id not in
  (
  select id from table where ST_Contains(
    ST_MakePolygon(
      ST_GeomFromText('LINESTRING(10.4588 63.4419, 10.4588 63.4018, 10.3496 63.4018, 10.3496 63.4419, 10.4588 63.4419)',4326)
    ), 
    geometryfield
  )
);