-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use either stddev_samp or stddev_pop depending on whether it's a
standard deviation over a sample or over the population.

On 2013-03-13 13:28, Anthony Damico wrote:
> Hello, I'm trying to run some old code with a recent upgrade of
> MonetDB and the standard deviation function appears to have
> disappeared.  I'm running MonetDB on Windows.
>
> This issue was previously discussed and resolved in this thread:
> http://old.nabble.com/users-list-Digest%2C-Vol-3%2C-Issue-8-tt34660082.html#a34660082
>
>  I could re-open this bug report if appropriate?
> http://bugs.monetdb.org/show_bug.cgi?id=2454#c18
>
> My server specs are below, and the actual commands below that.
>
> Thank you!!!
>
>
> # MonetDB 5 server v11.15.1 "Feb2013" # Serving database 'bsapuf',
> using 8 threads # Compiled for x86_64-pc-winnt/64bit with 64bit
> OIDs dynamically linked # Found 7.860 GiB available main-memory. #
> Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2013
> MonetDB B.V., all rights reserved # Visit http://www.monetdb.org/
> for further information # Listening for connection requests on

> mapi:monetdb://127.0.0.1:50003/ <http://127.0.0.1:50003/> #

> MonetDB/JAQL module loaded # MonetDB/SQL module loaded
>>
>
>
> c:\Program Files\MonetDB\MonetDB5>mclient -p 50003 "bsapuf"
> user(win32):monetdb password: Welcome to mclient, the MonetDB/SQL
> interactive terminal (Feb2013) Database: MonetDB v11.15.1
> (Feb2013), 'bsapuf' Type \q to quit, \? for a list of available
> commands auto commit mode: on sql>select sum( hha_pmt_amt ) from
> hha08; +-----------+ | L1        | +===========+ | 675676300 |
> +-----------+ 1 tuple (2.311ms) sql>select sum( hha_pmt_amt ), avg(
> hha_pmt_amt ) from hha08; +-----------+--------------------------+
> | L1        | L2                       |
> +===========+==========================+ | 675676300 |
> 5412.8151310993435 | +-----------+--------------------------+ 1
> tuple (63.559ms) sql>select sum( hha_pmt_amt ), median( hha_pmt_amt
> ) from hha08; +-----------+------+ | L1        | L2   |
> +===========+======+ | 675676300 | 3500 | +-----------+------+ 1
> tuple (9.601ms) sql>select sum( hha_pmt_amt ), stddev( hha_pmt_amt
> ) from hha08; SELECT: no such unary operator 'stddev(int)'
> sql>select sum( hha_pmt_amt ), sd( hha_pmt_amt ) from hha08;
> SELECT: no such unary operator 'sd(int)' sql>select sum(
> hha_pmt_amt ), sddev( hha_pmt_amt ) from hha08; SELECT: no such
> unary operator 'sddev(int)' sql>select sum( hha_pmt_amt ), var(
> hha_pmt_amt ) from hha08; SELECT: no such unary operator
> 'var(int)' sql>select sum( hha_pmt_amt ), variance( hha_pmt_amt )
> from hha08; SELECT: no such unary operator 'variance(int)'
> sql>select sum( hha_pmt_amt ), stdevp( hha_pmt_amt ) from hha08;
> SELECT: no such unary operator 'stdevp(int)' sql>
>
>

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

- --
Sjoerd Mullender
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.13 (GNU/Linux)
Comment: Using GnuPG with undefined - http://www.enigmail.net/

iQCVAwUBUUCBxj7g04AjvIQpAQIk8wP/VRY7ENvftuC2PSXt10DmIH7x+MQ774fR
wyn9xbbSLlfxmMOL6136v/gp4EqX2CBJkicaaKdSQRIj3xhIng9Qj+Gl57gfZc0U
9YCNu1RsRCTHdvtQ1Cjd2v6m4t4qfvgrd8eE2HUgtKI26Fo1ntT07gHVzyUQBNba
PKP4VmT1Rv8=
=RMD3
-----END PGP SIGNATURE-----

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