[R] Expected behavior of as.character ??

[Duncan Murdoch]

On 09/02/2011 11:11 AM, koooee wrote:
> is this the expected behavior of as.character ?
>
> resultset is a data.frame from a sqlQuery() using RODBC
>
> >  a = as.character(as.vector(resultset[1]))
> >  a
> [1] "c(-1, 1, 2, 3, 4, 5, 6, 7, 8, 9)"
>
> I would expect the statement above to return similar to the result below, am
> I missing something?

Yes, you should look at what

as.vector(resultset[1])

gives you.  I think it is not what you expected.  (Use str() to see that 
it is still a data frame).

Duncan Murdoch

> >  as.character(c(-1,1,2,3,4,5,6,7,8,9))
>   [1] "-1" "1"  "2"  "3"  "4"  "5"  "6"  "7"  "8"  "9"