STandard Deviation

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

STandard Deviation

Peter Haworth-2
Does Sqlite have a STDEV function?  Don;t see it listed under the core  
or aggregate functions.
Thanks,

Pete Haworth








_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: STandard Deviation

Gabor Grothendieck
Not in sqlite itself but stddev_samp and stddev_pop are available in
the spatialite loadable extension.
Be careful since they interchanged sample and population in one
version of the extension.

On Sun, Apr 18, 2010 at 9:37 PM, Peter Haworth <[hidden email]> wrote:

> Does Sqlite have a STDEV function?  Don;t see it listed under the core
> or aggregate functions.
> Thanks,
>
> Pete Haworth
>
>
>
>
>
>
>
>
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: STandard Deviation

Roger Binns
In reply to this post by Peter Haworth-2
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 04/18/2010 06:37 PM, Peter Haworth wrote:
> Does Sqlite have a STDEV function?  Don;t see it listed under the core  
> or aggregate functions.

You can find that and many other functions in a contributed extension.  See
the bottom of http://sqlite.org/contrib

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkvLysEACgkQmOOfHg372QT2xACgvnEXVX+Lj4Sl3ByjFqFmacWw
rrQAoNvDSa3VqCrITOW7mjPEx3Rtg7nx
=iQfv
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users