or if the name is a
SQL
keyword like 'where' or 'select'. If you are doing this from a function,
you may as well quote all the names.
-Bill
On Fri, Oct 2, 2020 at 6:18 PM Philip wrote:
The \”2B\” worked. Have no idea why. Can you point me somewhere that
can
expla
gt;
>
>
>
>
>
>
>
> On Fri, Oct 2, 2020 at 7:34 PM Bill Dunlap
> wrote:
> >
> > The double quotes are required by SQL if a name is not of the form
> > letter-followed-by-any-number-of-letters-or-numbers or if the name is a
> SQL
> > keyword l
t; The \”2B\” worked. Have no idea why. Can you point me somewhere that can
> > explain this to me.
> >
> > Thanks,
> > Philip
> >
> > *From:* Bill Dunlap
> > *Sent:* Friday, October 2, 2020 3:54 PM
> > *To:* Philip
> > *Cc:* r-help
> > *Sub
t 2, 2020 at 6:18 PM Philip wrote:
> The \”2B\” worked. Have no idea why. Can you point me somewhere that can
> explain this to me.
>
> Thanks,
> Philip
>
> *From:* Bill Dunlap
> *Sent:* Friday, October 2, 2020 3:54 PM
> *To:* Philip
> *Cc:* r-help
> *Subject:* Re:
Have you tried putting double quotes around 2B and 3B: "...2B, 3B, ..." ->
"...\"2B\",\"3B\",..."?
-Bill
On Fri, Oct 2, 2020 at 3:49 PM Philip wrote:
> I’m trying to pull data from one table (batting) in the Lahman Baseball
> database. Notice X2B for doubles and X3B for triples – fourth and f
I’m trying to pull data from one table (batting) in the Lahman Baseball
database. Notice X2B for doubles and X3B for triples – fourth and fifth from
the right.
The dbGetQuery function runs fine when I leave there two out but I get error
messages (in red) when I include 2B/3B or X2B/X3B.
Can
Ok, thanks to Prof Brian Ripley and to Elijah, I did the connection to
PostgeSQL database with RODBC, it's simple.
I will try with RdbiPgSQL in the next days.
Thanks a lot.
2007/10/31, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
>
>
>
> > I have some problems with DBI package, I want to connect to P
I have some problems with DBI package, I want to connect to PostgreSQL
database but I don't know the way to do it.
pg <- dbDriver("PostgreSQL")
... nope. That won't work.
you need the RdbiPgSQL package from Bioconductor. Along with DBI, as I
recall.
--elijah
On Wed, 31 Oct 2007, Germán Carrillo wrote:
Hello everyone!
Congratulations by this gorgeous software.
My name is Germán Carrillo, I'm writting from Colombia. I don't have much
experience with R, reason why I use the R-GUI (version 2.5.1) on Windows.
I have some problems with DBI package, I w
Hello everyone!
Congratulations by this gorgeous software.
My name is Germán Carrillo, I'm writting from Colombia. I don't have much
experience with R, reason why I use the R-GUI (version 2.5.1) on Windows.
I have some problems with DBI package, I want to connect to PostgreSQL
database but I don
10 matches
Mail list logo
