Subject | Re: [firebird-support] Aggregate UDF? |
---|---|
Author | Ann W. Harrison |
Post date | 2010-06-24T14:36:50Z |
Car Toper wrote:
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
> 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