On Mar 6, 2012, at 9:08 AM, Ben Madin wrote:
> Hi Puneet,
>
> Did it work when you removed the offending semicolon, as described in the
> syntax error message?
Ben,
To be honest, I didn't try that approach. I am in a hurry for a presentation
this aft, so I wanted to get this rolling, and will try that later.
That said, I am not sure if that semicolon is the offender. Assuming the error
trace is identifying the correct line, the offending line is (I have cleaned it
up to reflect modern usage, Pg 9, PostGIS 1.5.x, etc.)
points <- pg.spi.exec(sprintf("SELECT ST_X(%2$s) AS x, ST_Y(%2$s) AS y
FROM %1$s;",arg1,arg2))
The semicolon, afaict, is required to construct the correct SQL statement. For
now, I hard coded the statement like so, and it works
points <- pg.spi.exec("SELECT ST_X(the_geom) AS x, ST_Y(the_geom) AS y
FROM mytable;")
>
> cheers
>
> Ben
>
>
>
> On 06/03/2012, at 11:52 AM, Puneet Kishor wrote:
>
>>
>> On Mar 5, 2012, at 9:44 PM, Derek Jones wrote:
>>
>>> Hi all,
>>>
>>> I have used an R solution that works well with the plsql to do this. Found
>>> here:
>>>
>>> http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut02
>>>
>>> Needed some mods for my local solution, but helpful.
>>>
>>
>>
>> Yes, I tried that, but as I noted in my earlier email, I got the following
>> error
>>
>> ERROR: R interpreter expression evaluation error
>> DETAIL: Error in pg.spi.exec(sprintf("select x(%2$s) as x, y(%2$s) as y
>> from %1$s;", :
>> error in SQL statement : syntax error at or near ";"
>> CONTEXT: In R support function pg.spi.exec
>> In PL/R function voronoi
>>
>>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
