hello, just an idea--

if monetdb gets a flood of new R users over the next year, they might get thrown off by things breaking when they use a double-equals sign (example below).. sqlite accepts the double-equals as a single equals.

thanks

dbGetQuery(db,'select count(distinct mycolumn) from mytable where

yr=2003') L1 1 334343

dbGetQuery(db,'select count(distinct mycolumn) from mytable where

yr==2003') Error in .local(conn, statement, ...) : Unable to execute statement 'select count(distinct mycolumn) from mytable where yr==2003'. Server says 'syntax error, unexpected '=' in: "select count(distinct mycolumn) from mytable where yr=="' [#42000].