[R] multi-line query

[Gabor Grothendieck]

On Tue, Nov 8, 2011 at 1:04 PM, Ben quant <ccquant at gmail.com> wrote:
> Because I don't know anything about sqldf. :)
>
> Here is what happens, but I"m sure it is happening because I didn't read
> the manual yet:
>
>> s <- sqldf('create table r.dat("id" int primary key,"val" int)')
> Error in ls(envir = envir, all.names = private) :
>  invalid 'envir' argument
> Error in !dbPreExists : invalid argument type
>

Assuming you have loaded RpgSQL and sqldf it works for me so there is
likely some configuration in your setup, either with RpgSQL or with
PostgreSQL itself.

> s <- sqldf('create table dat("id" int primary key, "val" int)')
> sqldf("select * from dat")
[1] id  val
<0 rows> (or 0-length row.names)

If you are going to use your own create statements then you might be
better off using RpgSQL directly rather than sqldf.

-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com