[postgis-users] UPDATE syntax

Willy-Bas Loos willybas at gmail.com
Sat Jan 12 03:12:55 PST 2013


what's the error message?


On Fri, Jan 11, 2013 at 10:09 PM, Jeff Lake <jeff at michiganwxsystem.com>wrote:

>  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>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>


-- 
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130112/375cb1aa/attachment-0001.html>


More information about the postgis-users mailing list