[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