Re: Design Question (Time Series Data) - Mailing list pgsql-general

On 10/4/07, Ted Byers <r.ted.byers@rogers.com> wrote:
> --- Michael Glaesemann <grzm@seespotcode.net> wrote:
>
> >
> > On Oct 4, 2007, at 9:30 , Ted Byers wrote:
> >
> > > I do not know if PostgreSQL, or any other RDBMS,
> > > includes the ability to call on software such as
> > "R"
> >
> > See PL/R:
> >
> > http://www.joeconway.com/plr/
> >
> Thanks.  Good to know.

See also RdbiPgSQL
(http://bioconductor.org/packages/2.0/bioc/html/RdbiPgSQL.html)

PL/R lets you write R functions as procedural functions you can call
from pgsql (e.g. select my_r_function(myfield) from mytable. RdbiPgSQL
creates R functions you can use to query pgsql from within R.

-Josh/eggyknap