Hi,

could some one possible explain to me
why the MonetDB corr() aggregate function,
that IMHO is supposed to calculate the correlation between two attributes,
does return the same type as (the larger of) its input type(s)?

IMHO the correlation between two attributes (or (samples of) random variables
is a factional value between -1 and 1.

Consequently, MonetDB corr() on two integer columns returns an integer results,
i.e., one of {-1,0,1} ...

Shouldn't corr() --- much like avg(), var_pop(), var_samp(), stddev_samp(), stddev_pop()
always return type double ?

Thanks!

Best,
Stefan

--
| 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
https://www.monetdb.org/mailman/listinfo/users-list