[R-sig-DB] DBI column names
Gabor Grothendieck
ggrothend|eck @end|ng |rom gm@||@com
Sun Jul 22 03:01:21 CEST 2007
It seems that the DBI package changes column names that have
dots in them replacing the dots with underscores. Is this really
necessary? I understand that dot is an SQL operator; nevertheless,
SQLite can handle column names with dots and I suspect other
databases can too:
C:\tmp2>sqlite3
SQLite version 3.4.0
Enter ".help" for instructions
sqlite> create table mytable (`my.field` integer);
sqlite> insert into mytable(`my.field`) values (1);
sqlite> select `my.field` from mytable;
1
More information about the R-sig-DB
mailing list