Re: [R] retrieving large columns using RODBC

2005-08-15 Thread bogdan romocea
SQL help. -Original Message- From: Tamas K Papp [mailto:[EMAIL PROTECTED] Sent: Saturday, August 13, 2005 4:03 AM To: R-help mailing list Subject: [R] retrieving large columns using RODBC Hi, I have a large table in Postgresql (result of an MCMC simulation, with 1 million

Re: [R] retrieving large columns using RODBC

2005-08-15 Thread Prof Brian Ripley
. -Original Message- From: Tamas K Papp [mailto:[EMAIL PROTECTED] Sent: Saturday, August 13, 2005 4:03 AM To: R-help mailing list Subject: [R] retrieving large columns using RODBC Hi, I have a large table in Postgresql (result of an MCMC simulation, with 1 million rows) and I would like

[R] retrieving large columns using RODBC

2005-08-13 Thread Tamas K Papp
Hi, I have a large table in Postgresql (result of an MCMC simulation, with 1 million rows) and I would like to retrive colums (correspond to variables) using RODBC. I have a column called index which is used to order rows. Unfortunately, sqlQuery can't return all the values from a column at