search

greenplum-db / PivotalR-archive

An convenient R tool for manipulating tables in PostgreSQL type databases and a wrapper of Apache MADlib.
https://pivotalsoftware.github.io/gp-r/
125 stars 53 forks source link

date operations in sql wrapper #18

Closed mwillumz closed 10 years ago

mwillumz commented 10 years ago

Hi again. Wondering if something like:

WHERE date_a-date_b>365

using 

Data[Data$date_a-Data$date_b>365,]

or 

SELECT MAX(date) FROM X

using

Data$maxdate <- max(Data$date)

will be supported in the future.

walkingsparrow commented 10 years ago

Yes, these will be supported. Actually it should be very simple. Let me try to add the support for these over this weekend.

walkingsparrow commented 10 years ago

Try date_ops branch, please. Welcome any feedback.

walkingsparrow commented 10 years ago

Later it will be merged into master.

walkingsparrow commented 10 years ago

The branch is almost done but needs more testing.

walkingsparrow commented 10 years ago

Merged into master at v0.1.15.27.