[R-sig-DB] Data type error with RpgSQL on Windows XP SP3 32bit

[Xiaobo Gu]

Hi,
What's the versions for all the related components, R, DBI, rJava,RJDBC,
RpgSQL, PostgreSQL JDBC?

Regards,

Xiaobo Gu


On Mon, Nov 1, 2010 at 1:10 AM, Dirk Eddelbuettel <edd using debian.org> wrote:

>
> On 31 October 2010 at 13:03, Gabor Grothendieck wrote:
> | On Sun, Oct 31, 2010 at 9:26 AM, Dirk Eddelbuettel <edd using debian.org>
> wrote:
> | > Try casting the (SQL) date to (SQL) character, you can probably load
> the
> | > character into R and parse again as an (R) Date.
> | >
> |
> | RpgSQL directly supports Date type.  It should not be necessary to
> | convert it to a character.
>
> Thanks for the clarification.  I didn't mean to imply that RpgSQL didn't
> have
> this feature and was just trying to help the OP with an alternate approach.
>
> Dirk
>
> --
> Dirk Eddelbuettel | edd using debian.org | http://dirk.eddelbuettel.com
>

	[[alternative HTML version deleted]]