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" <anshuman.kumar@flowedge.in> 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