Subject Re: [firebird-support] Aggregate UDF?
Author Ann W. Harrison
Car Toper wrote:
> Does Firebird support aggregate UDF's?
>

In a word, no.

It is difficult and somewhat dangerous to access a Firebird
database from a UDF. The UDF does not inherit the context of
the transaction that invokes it, so it has to make a separate
connection and start a separate transaction which will see
a different snapshot of the database than the original transaction.

Look at the built-in functions first, then try a combination
of a stored procedure and, if necessary, a computational UDF.


Cheers,

Ann