[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