[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