<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div id="gt-res-content" class="almost_half_cell">
<div dir="ltr" style="zoom:1">
<div id="tts_button" style="" class=""><object
type="application/x-shockwave-flash"
data="http://www.gstatic.com/translate/sound_player2.swf"
id="tts" height="18" width="18"></object></div>
<span id="result_box" class="" lang="en"><span class="hps">hello</span><span>,</span><br>
<br>
<span class="hps">I</span> <span class="hps">have a table
with</span> <span class="hps">two columns</span> <span
class="hps">'<b>lat</b></span><span>'</span> <span
class="hps">and</span> <span class="hps">'<b>lon</b></span><span>'</span>
<span class="hps">: it is real</span> <span class="hps">type</span>
<span class="hps">double and a </span><span class="hps">column</span>
<span class="hps atn">'</span><b><span>geom</span></b><span>'</span>
<span class="hps">type</span> <span class="hps">geometry</span><span>;</span><br>
<span class="hps">how to make a</span> <span class="hps">request</span>
<span class="hps">to update</span> <span class="hps">my
column</span> <span class="hps">geom</span> <span
class="hps">from</span> <span class="hps">'lat</span><span>'</span>
<span class="hps">and</span> <span class="hps">'lon</span><span>'
columns ?</span><span></span><br>
<span class="hps">somewhat</span> <span class="hps"></span><span
class="hps">I wrote</span> this : <br>
<b><span class="hps">update</span> <span class="hps">mytable</span>
<span class="hps">set</span> <span class="hps">geom</span>
<span class="hps atn">= '</span><span>POINT</span> <span
class="hps atn">(</span><span>' | |</span> <span
class="hps">lat</span> <span class="hps atn">| | '</span><span>'
| |</span> <span class="hps">lon</span> <span
class="hps">| |</span> <span class="hps">')'</span><span>;</span></b><br>
<span class="hps">but</span> <span class="hps">it does not
work</span><span>!</span><br>
<span class="hps">Do you have</span> <span class="hps">an
idea</span><span>?</span><br>
<span class="hps">thank you</span><br>
<br>
<br>
<span class="hps">my config</span><br>
<span class="hps">Windows</span> <span class="hps">XP</span>
<span class="hps">Pro</span> <span class="hps">SP2</span><br>
<span class="hps">PostGIS</span> <span class="hps">1.5.3</span></span></div>
</div>
<div class="moz-signature">-- <br>
<title>VBLC Signature</title>
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta content="MSHTML 6.00.6000.16640" name="GENERATOR">
<div align="left">
<hr></div>
<div align="left">
<table id="table1" border="0" width="42%">
<tbody>
<tr>
<td width="172"><br>
</td>
<td><br>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</body>
</html>