Hi all, I'm trying to run a simple standard deviation function on a column using MonetDB --
select stdev( columnname ) from tablename
-- is this possible with the current release? The only posts I can find about stdev() or variance() are quite old, such as
a 2008 post requesting medians (which has been implemented) and quantiles (which I cannot find?)
http://osdir.com/ml/db.monetdb.bugs/2008-06/msg00206.html
a 2010 post offering to add these functions to the main release code.
http://mail.monetdb.org/pipermail/users-list/2010-January/003836.html
What would be the easiest way to get MonetDB to produce standard deviations, variances, and quantiles (let's say the 25th percentile)?
From the discussion list, it looks like people have succeeded in doing it, but they're probably much more advanced users than I am. ;)
Thanks!!!