Tests if a geometry value crosses another geometry value.
SELECT NEW ST_LineString( 'LineString( 0 0, 2 2 )' ) .ST_Crosses( NEW ST_LineString( 'LineString( 0 2, 2 0 )' ) )
The following examples returns the result 0 because the interiors of the two lines do not intersect (the only intersection is at the first linestring boundary).
SELECT NEW ST_LineString( 'LineString( 0 1, 2 1 )' ) .ST_Crosses( NEW ST_LineString( 'LineString( 0 0, 2 0 )' ) )
The following example returns NULL because the first geometry is a surface.
SELECT NEW ST_Polygon( 'Polygon(( 0 0, 0 1, 1 0, 0 0))' ) .ST_Crosses( NEW ST_LineString( 'LineString( 0 0, 2 0 )' ) )
SQL/MM (ISO/IEC 13249-3: 2006) 5.1.29