[postgis-users] Clip and dump SHP file

[eifelgeist.com]

Hello Together,

I try perform a clip operation on a spacial database table. Selecting 
the geometry works so far ..

SELECT outsymbol,
intersection  (the_geom,GeomFromText('BOX3D(120 30,150 40)'::box3d,-1))
FROM table1
WHERE
the_geom && GeomFromText('BOX3D(120 30,150 40)'::box3d,-1)

BUT when I dump the result to a shapefile via shp2pgsql the lineshapes 
are dissolved into its points. My question now is, how can I perform a 
clipping operation on lines or polygons which cuts the object at the 
clipbox edge ??

Thanx for any help !

Cheers

Chris