You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Narayanan <V....@Sun.COM> on 2008/03/14 01:18:27 UTC

Re: STDDEV for Derby

Art Majtenyi wrote:
>
> Reference manual says, "You can also create your own aggregates to 
> perform other set functions such as calculating the standard deviation."
> Has anyone done this?...Is there any docs to help with this?...It's 
> not as easy as a scalar function.
>
> Art Majtenyi, amajteny@us.ibm.com
> WebSphere Business Monitor Development
> IBM Corporation, RTP, NC
> O: 919/254-4443, M: 919/302-8827
>
Hi,

Derby supports Java Stored procedures which can be used to create any 
function of your choice. You can find more
information about this here

http://wiki.apache.org/db-derby/DerbySQLroutines

Narayanan