[MonetDB.R] MONTH_INTERVAL

[Роман Кисленок]

Got an error from MonetDB.R on select:
<simpleError in monetdbRtype(info$types[i]): Unknown DB type MONTH_INTERVAL>

You can get this just by doing:
dbGetQuery(conn, "select cast('2015-03-02' as date) - cast('2015-03-01' as
date)")

May be it should be integer number:
dbGetQuery(conn, "select cast(cast('2015-03-02' as date) -
cast('2015-03-01' as date) as integer)")


-- 
Roman Kislenok
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.r-forge.r-project.org/pipermail/monetr-users/attachments/20150413/477d04f2/attachment.html>