INSERT INTO sample_shapes SELECT skey, new ST_Geometry( 'LINESTRING (2 2,3 2,4 1)').ST_Intersection(streetShape) FROM sample_streets WHERE new ST_Geometry( 'MultiPoint((2 2),(3 2))').ST_Intersects(streetShape) = 1;
INSERT INTO sample_shapes SELECT skey, new ST_Geometry( 'LINESTRING (2 2,3 2,4 1)').ST_Intersection(streetShape) FROM sample_streets WHERE new ST_Geometry( 'MultiPoint((2 2),(3 2))').ST_Intersects(streetShape) = 1;