[postgis-users] Casting a point and a polygon to geometry

[Roba Binyahib]

Dear all

I want to use the following query

ST_Crosses(geometry g1, geometry g2);

but I want g1 to be column of points and g2 a column of geometry, so how
can I convert them to geometry enable to use the function


this is my query

select r.name,u.id from river r, users u where
ST_Crosses(r.point,u.polygon)='T' ;


hope you can help

thanks



---------------------------

Best Regards,
Roba

-- 

------------------------------
This message and its contents, including attachments are intended solely 
for the original recipient. If you are not the intended recipient or have 
received this message in error, please notify me immediately and delete 
this message from your computer system. Any unauthorized use or 
distribution is prohibited. Please consider the environment before printing 
this email.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120709/7a480f4d/attachment.html>