Given a "road", represented by a line, that crosses a "state", represented by a polygon:
What is the SQL query I can use to find the segment of the road that is within the state?
A concrete example.
I have a single line representing Route 66 which traverses the USA. I also have polygons for each state. I want to find the segment of Route 66 that lies within Texas.