[postgis-users] UPDATE syntax

[Jeff Lake]

I have an already established table..
using a php script to run periodic updates to the GIS data
I have seen all kinds of INSERT and SELECT unless I'm missing it no 
UPDATE ??
would the following work??
$polygon is Latitude Longitude pairings

"UPDATE conv SET geom = ST_GeomFromText('LINESTRING(".$polygon.")', -1) 
WHERE wwnum = '".$wnum."'"
-- 
*Jeff Lake*
MichiganWxSystem <http://www.michiganwxsystem.com>
AllisonHouse <http://www.allisonhouse.com>
GRLevelXStuff <http://www.grlevelxstuff.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130111/80e087d3/attachment.html>