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"
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