[postgis-users] Retrieve Line coordinates from geometry.

[Broun Uganda]

Dear all,Am trying to use the postgis reference to extract coordinates (x & y) for the starting and ending of a line from the_geom to enable me draw points at the starting and ending of that line. Please advise me which function i should use in my trigger function. I want to do something like this: UPDATE points SET the_geom = MakePoint(New.lines.the_geom(s),-1); where (s) refers to start of line geometry & (e) refers to end  of line geometryUPDATE points SET the_geom = MakePoint(New.lines.the_geom(e),-1); ThanksBroun 
_________________________________________________________________
With Windows Live Hotmail, you can personalize your inbox with your favorite color.
www.windowslive-hotmail.com/learnmore/personalize.html?locale=en-us&ocid=TXT_TAGLM_HMWL_reten_addcolor_0607
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070705/85706774/attachment.html>