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].
>
