On 03/20/12 7:49 PM, Jim Green wrote:
yes its possible but I would more likely grab the data to R and get the avg in R..
avg() in the database is going to be a lot faster than copying the data into memory for an application to process.
Also, you know there's a plR for postgres that lets you embed R functions in the database server and invoke them in SQL statements??
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general