Displaying 1 result from an estimated 1 matches for "position__1".
Did you mean:
position1
2009 Sep 27
1
RSQLite column names underscores
...WriteTable(...) function, the columns in the db
table frequently end up having "__1" (two underscores and a one) added
to them. The names are unique within the table and contain no weird
characters. For example a "position" column from a data.frame was
written to the DB as "position__1".
Does anyone understand how this name munging happens and how I can
prevent or work around it? Having these suffixes added seemingly
arbitrarily makes it hard to construct the next query.
Thanks for any hints,
-chris