Re: [SQL] Sqldf - error message

2009-11-20 Thread Whit Armstrong
Luc, You need to contact Gabor Grothendieck (cc'd) about this issue. He is the package author. I'm sure he will be happy to help. -Whit On Fri, Nov 20, 2009 at 11:23 AM, Adrian Klaver wrote: > On Friday 20 November 2009 6:43:53 am Pavel Stehule wrote: >> 2009/11/20 Tom Lane : >> > "Marvelde,

Re: [SQL] Sqldf - error message

2009-11-20 Thread Adrian Klaver
On Friday 20 November 2009 6:43:53 am Pavel Stehule wrote: > 2009/11/20 Tom Lane : > > "Marvelde, Luc te" writes: > >> If I run this SQL query: > >>> sqldf("SELECT > >> > >> + dbo_tbl_Terrein.RingCentraleNaam, > >> + dbo_tbl_Broedsels.BroedselID > >> + FROM ((dbo_tbl_BroedselLocatie > >> + INNER J

Re: [SQL] Sqldf - error message

2009-11-20 Thread Rob Sargent
at cant be the problem > > Luc > > -Original Message- > From: Pavel Stehule [mailto:pavel.steh...@gmail.com] > Sent: vrijdag 20 november 2009 15:38 > To: Marvelde, Luc te > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] Sqldf - error message > > Hello >

Re: [SQL] Sqldf - error message

2009-11-20 Thread Marvelde, Luc te
:38 To: Marvelde, Luc te Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Sqldf - error message Hello 2009/11/20 Marvelde, Luc te : > Hi All! > > I just discovered sqldf and im very enthousiastic, as I am a big fan > of R and I often get frustrated using Access for datamanagement.

Re: [SQL] Sqldf - error message

2009-11-20 Thread Pavel Stehule
2009/11/20 Pavel Stehule : > Hello > > 2009/11/20 Marvelde, Luc te : >> Hi All! >> >> I just discovered sqldf and im very enthousiastic, as I am a big fan of R >> and I often get frustrated using Access for datamanagement. >> >> I tried running some queries from Access in R, and it works very well.

Re: [SQL] Sqldf - error message

2009-11-20 Thread Pavel Stehule
Hello 2009/11/20 Marvelde, Luc te : > Hi All! > > I just discovered sqldf and im very enthousiastic, as I am a big fan of R > and I often get frustrated using Access for datamanagement. > > I tried running some queries from Access in R, and it works very well. > However, I have problems with some

Re: [SQL] Sqldf - error message

2009-11-20 Thread Pavel Stehule
2009/11/20 Tom Lane : > "Marvelde, Luc te" writes: >> If I run this SQL query: > >>> sqldf("SELECT >> + dbo_tbl_Terrein.RingCentraleNaam, >> + dbo_tbl_Broedsels.BroedselID >> + FROM ((dbo_tbl_BroedselLocatie >> + INNER JOIN dbo_tbl_Broedsels ON dbo_tbl_BroedselLocatie.BroedselID = >> dbo_tbl_Broed

Re: [SQL] Sqldf - error message

2009-11-20 Thread Tom Lane
"Marvelde, Luc te" writes: > If I run this SQL query: >> sqldf("SELECT > + dbo_tbl_Terrein.RingCentraleNaam, > + dbo_tbl_Broedsels.BroedselID > + FROM ((dbo_tbl_BroedselLocatie > + INNER JOIN dbo_tbl_Broedsels ON dbo_tbl_BroedselLocatie.BroedselID = > dbo_tbl_Broedsels.BroedselID) > + INNER JOIN

[SQL] Sqldf - error message

2009-11-20 Thread Marvelde, Luc te
Hi All! I just discovered sqldf and im very enthousiastic, as I am a big fan of R and I often get frustrated using Access for datamanagement. I tried running some queries from Access in R, and it works very well. However, I have problems with some queries. If I run this SQL query: > sqldf("SELE