I need to use several aggregate functions, including most of the built-in aggregates (count, min, max, avg, etc.) as well as some custom aggregates (standard deviation and various percentiles).
Is there any documentation or example on how to create custom aggregate functions? I have found one reference [1] which only mentions that custom aggregates can be created, but contains no other details. (Also, are there any plans to include standard deviation or percentiles as built-in aggregates in derby?) [1] http://db.apache.org/derby/docs/10.2/ref/rrefsqlj33923.html#rrefsqlj33923__sqlj92398