Re: standard deviation in SQL

Indeed, please see this mailing list posting (and its followups) http://mail.monetdb.org/pipermail/users-list/2013-March/005925.html and this bug report http://bugs.monetdb.org/show_bug.cgi?id=3257 Stefan ----- Original Message -----

In the last few days I remember seeing one of the developers say that there was some code that was accidentally omitted. There are two functions one for samples and one for population stddev, but I can not remember right off what the endings of the functions are.

Brandon

Sent from my iPhone

On Mar 15, 2013, at 5:46 AM, "Anshuman Kumar" wrote:

...

Hi, I’m trying to find an aggregate function to find standard deviation. Does monetDB support such a function?

For example:- to find the average of the selected values we can use- Select AVG(age) from students where grade = 4;

I was taking the help of google and found this link- http://old.nabble.com/users-list-Digest,-Vol-3,-Issue-8-td34660082.html Then I tried the solution given by Percy Wegmann in the above link. After that when I run this query- Select STDEV(age) from students where grade = 4; [Age being a column of type double AND I get similar kind of error for int] I get this error – TypeException:user.s1_1[21]:'aggr.stddev' undefined in: _33:any := aggr.stddev(_ 32:bat[:oid,:dbl]) program contains errors

I need to have this function working in order to be able to use MonetDB. Kindly help.

Regards, Anshuman _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |