[MonetDB.R] MONTH_INTERVAL

[Hannes Mühleisen]

Hi Roman,

> On 13 Apr 2015, at 07:36, Роман Кисленок <kislenok.roman at gmail.com> wrote:
> 
> 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)")

You are correct, this is not supported yet. But it should be, this is why I have added it to the connector just now. Let me know how it goes

Here is the corresponding NEWS entry:
- Added support for esoteric data types such as MONTH_INTERVAL (Thanks, Roman)
- Cleaned up SQL to R type mapping (we had this twice)
- Now creating actual R integers if SQL data fits

You can download the 0.9.8 pre-release there:
http://homepages.cwi.nl/~hannes/R/MonetDB.R_0.9.8-0427ba916f4a.tar.gz


Best,

Hannes
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4154 bytes
Desc: not available
URL: <http://lists.r-forge.r-project.org/pipermail/monetr-users/attachments/20150413/ab6070f9/attachment.bin>