db-derby-user mailing list archives

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