[postgis-users] UPDATE syntax

Jeff Lake jeff at michiganwxsystem.com
Sat Jan 12 06:10:14 PST 2013


No error yet,
Just wondering if that is correct ??


*Jeff Lake*
MichiganWxSystem <http://www.michiganwxsystem.com>
AllisonHouse <http://www.allisonhouse.com>
GRLevelXStuff <http://www.grlevelxstuff.com>
On 1/12/2013 6:12, Willy-Bas Loos wrote:
> what's the error message?
>
>
> On Fri, Jan 11, 2013 at 10:09 PM, Jeff Lake <jeff at michiganwxsystem.com 
> <mailto: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 <mailto: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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130112/8b86b685/attachment.html>


More information about the postgis-users mailing list