<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>RE: [postgis-users] HELP adding spatial field to table</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Richard:<BR>
<BR>
> Next (and where the trouble lies)<BR>
><BR>
> UPDATE crimetest<BR>
> SET geom = PointFromText('POINT(' || x || ' ' || y || ')', 4326)<BR>
><BR>
<BR>
try:<BR>
ST_MakePoint(<x>, <y>, [<z>], [<m>])<BR>
<BR>
Creates a 2d,3dz or 4d point geometry.<BR>
<BR>
Less messing around with making a test string ...<BR>
<BR>
HTH,<BR>
<BR>
Greg Williamson<BR>
Senior DBA<BR>
GlobeXplorer LLC, a DigitalGlobe company<BR>
<BR>
Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those provisions. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.<BR>
<BR>
(My corporate masters made me say this.)<BR>
</FONT>
</P>
</BODY>
</HTML>