Folks,

for the record, in my original post I stated "standard deviation among
others". I don't actually need standard deviation, I used that
because I figured it would be the best 'complex' algorithm solved with
an aggregate udf.

The short answer is: Firebird doesn't support aggregate udf as of
today, so the problem will need to be solved some other way.

Now that I know this, I am starting to forulate other solutions, just
not as clean and simple as a aggregate udf:)

Cartoper

On Wed, Jun 23, 2010 at 6:55 PM, Car Toper <cartoper@...> wrote:

> I need to do some advanced calculations, standard deviation among
> others.  So what I need to do is create a UDF which is an aggregate
> function.  I am currently using SQLite and am porting the system to
> support both SQLite and Firebird.  SQLite does support UDF that are
> both scalar and aggregate functions.