[postgis-users] UPDATE syntax

[Willy-Bas Loos]

Well it looks ok, but it's not pure SQL.
You should just test it.


On Sat, Jan 12, 2013 at 3:10 PM, Jeff Lake <jeff at michiganwxsystem.com>wrote:

>  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>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
>
>
> _______________________________________________
> postgis-users mailing listpostgis-users at lists.osgeo.orghttp://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> 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/22457cf6/attachment.html>