Re: standard deviation in SQL

Dear Anshuman, we fully understand you comment. However, our resources are unfortunately often too limited to keep our documentation up-to-date with the development of our system and its growing functionality. Please bear with us. Best, Stefan ----- Original Message -----

Thanks for the prompt reply Bandon and Stefan. I was digging through the documentation for monetDB, but was unable to locate any topic which covers all the supported mathematical functions. Would make life of the users much more easier!

Thanks a lot, Anshuman

-----Original Message----- From: users-list-bounces+anshuman.kumar=flowedge.in@monetdb.org [mailto:users-list-bounces+anshuman.kumar=flowedge.in@monetdb.org] On Behalf Of Stefan Manegold Sent: 15 March 2013 16:33 To: Communication channel for MonetDB users Subject: 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.h tml 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) |

_______________________________________________ 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) |