Is it possible to select line's some part?

Oct 30, 2014 at 8:06 AM
Edited Oct 30, 2014 at 8:09 AM
Hello,
I want to select line's some part. How can I do it?
I have postgis database.

I add a line on my postgis database.
INSERT INTO roads VALUES
 
  (1,ST_GeomFromText('LineString(0 0,0 10, 0 20, 0 30, 0 40, 10 40, 20 40, 30 40, 40 40)',4326),'NEW_ROAD','TR', 'MR', 'IST', 'BSK', 'MOTORWAY',0, 'A');
image 1
Image


image 2
Image
As you see image 2 . I have a line with nodes.
I want to select my line like image 3.
İs it possible?
Thank you for your reply.

image 3
Image