[postgis-users] How to get point where ST_Crosses ?

[Maxime van Noppen]

On 09/22/09 13:44, Tuomas Ruohonen wrote:
> Hi all,
> 
> How I can get POINT where two linestrings are crossing ? I am now using
> st_crosses to linestrings.

Hi,

ST_Intersection seems to be what you're looking for :

http://postgis.refractions.net/documentation/manual-1.4/ST_Intersection.html

-- 
Maxime