Richard:
> Next (and where the trouble lies)
>
> UPDATE crimetest
> SET geom = PointFromText('POINT(' || x || ' ' || y || ')', 4326)
>
try:
ST_MakePoint(<x>, <y>, [<z>], [<m>])
Creates a 2d,3dz or 4d point geometry.
Less messing around with making a test string ...
HTH,
Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company
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.
(My corporate masters made me say this.)
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
