I know it's probably a long shot, but has anyone coded statistical
distributions as functions in PostgreSQL? Specifically, I'm looking
for a function to calculate the cumulative F distribution.

By the way, I know that I can do /df at the psql command line to list
the available functions. Is there a help function or better
description for a given function? Specifically, I'd like to know what
array_in and array_out do.

Thanks
-Tony

15 Mar 2002 17:20:09 -0800
reina@nsi.edu (Tony Reina)
Anyone have a SQL code for cumulative F distribution function?
Tony Reina wrote:
> I know it's probably a long shot, but has anyone coded statistical
> distributions as functions in PostgreSQL? Specifically, I'm looking
> for a function to calculate the cumulative F distribution.
> 
> By the way, I know that I can do /df at the psql command line to list
> the available functions. Is there a help function or better
> description for a given function? Specifically, I'd like to know what
> array_in and array_out do.
> 
> Thanks
> -Tony
> 

Not quite what you asked for, but there *is* a library which allows you 
to query data from a PostgreSQL database from within R, called RPgSQL. 
Its available on Sourceforge and from the R Archive: 
http://cran.r-project.org/

Joe




Fri, 15 Mar 2002 18:30:21 -0800
Joe Conway <mail@joeconway.com>
Re: Anyone have a SQL code for cumulative F distribution function?