you need a space between the ordinates and you need to put the longitude first.<div>P.<br><br><div class="gmail_quote">On Tue, Mar 13, 2012 at 1:52 PM, francis <span dir="ltr"><<a href="mailto:francis.milhau@free.fr">francis.milhau@free.fr</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  

    
  
  <div bgcolor="#FFFFFF" text="#000000">
    <div>
      <div dir="ltr" style="zoom:1">
        <div></div>
        <span lang="en"><span>hello</span><span>,</span><br>
          <br>
          <span>I</span> <span>have a table
            with</span> <span>two columns</span> <span>'<b>lat</b></span><span>'</span> <span>and</span> <span>'<b>lon</b></span><span>'</span>
          <span>: it is real</span> <span>type</span>
          <span>double and a </span><span>column</span>
          <span>'</span><b><span>geom</span></b><span>'</span>
          <span>type</span> <span>geometry</span><span>;</span><br>
          <span>how to make a</span> <span>request</span>
          <span>to update</span> <span>my
            column</span> <span>geom</span> <span>from</span> <span>'lat</span><span>'</span>
          <span>and</span> <span>'lon</span><span>'
            columns ?</span><span></span><br>
          <span>somewhat</span> <span></span><span>I wrote</span> this : <br>
          <b><span>update</span> <span>mytable</span>
            <span>set</span> <span>geom</span>
            <span>= '</span><span>POINT</span> <span>(</span><span>' | |</span> <span>lat</span> <span>| | '</span><span>'
              | |</span> <span>lon</span> <span>| |</span> <span>')'</span><span>;</span></b><br>
          <span>but</span> <span>it does not
            work</span><span>!</span><br>
          <span>Do you have</span> <span>an
            idea</span><span>?</span><br>
          <span>thank you</span><br>
          <br>
          <br>
          <span>my config</span><br>
          <span>Windows</span> <span>XP</span>
          <span>Pro</span> <span>SP2</span><br>
          <span>PostGIS</span> <span>1.5.3</span></span></div><span class="HOEnZb"><font color="#888888">
    </font></span></div><span class="HOEnZb"><font color="#888888">
    <div>-- <br>
      
      
      
      <div align="left">
        <hr></div>
      <div align="left">
        <table border="0" width="42%">
          <tbody>
            <tr>
              <td width="172"><br>
              </td>
              <td><br>
              </td>
            </tr>
          </tbody>
        </table>
      </div>
    </div>
  </font></span></div>

<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div>