<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=232394214-21052008><FONT face=Arial
color=#0000ff size=2>One thought</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=232394214-21052008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=232394214-21052008><FONT face=Arial
color=#0000ff size=2>SELECT REPLACE(REPLACE(REPLACE(astext(the_geom),
geometrytype(the_geom), ''),'(',''), ')','') as coords</FONT></SPAN></DIV>
<DIV><SPAN class=232394214-21052008></SPAN><SPAN class=232394214-21052008><FONT
face=Arial color=#0000ff size=2>FROM mytable</FONT></SPAN></DIV>
<DIV><SPAN class=232394214-21052008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=232394214-21052008><FONT face=Arial color=#0000ff size=2>If you
know the geometrytype already, might be faster to hard-code that.</DIV>
<DIV><BR></DIV></FONT></SPAN>
<DIV><SPAN class=232394214-21052008></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>H<SPAN class=232394214-21052008>ope that
helps,</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT><FONT color=#0000ff><FONT size=2><SPAN
class=232394214-21052008></SPAN></FONT></FONT></FONT><SPAN
class=232394214-21052008></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2>R<SPAN
class=232394214-21052008>egina</SPAN></FONT></FONT></FONT><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Bui
Anh Tin<BR><B>Sent:</B> Wednesday, May 21, 2008 10:27 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] Get
Coordinate Line Or Polyline Or Point<BR></FONT><BR></DIV>
<DIV></DIV>hi all<BR>i am developing <A href="http://asp.net">asp.net</A> and
mapserver database postgresql<BR><BR>i have problem when get coordinate Line Or
Polyline Or Point<BR>I known query<BR>SELECT astext(the_geom) form
mytable<BR>reuslt:<BR>Point(x,y)<BR>Muntiline(x y, x1,y1, .....)<BR>How can i
get only coordinate x y, x1, y1 so havent text "point or Mutiline"
??<BR></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>