Subject Re: [firebird-support] aggregate product() or equivalent
Author Ann W. Harrison
unordained wrote:
>
> I don't suppose there's any way the plugin part of Firebird could be enhanced to allow aggregate
> UDF's?

Not easily. The UDF doesn't have access to internal state - the current
connection, transaction, request, etc. - and giving it that information
would be a serious design challenge. Not that it doesn't come up from
time to time, but we'd need to design an interface that can be held
stable to internal structures that will certainly change in the next
couple of releases.

What has been seriously discussed is a a "stored function" - something
that works like a stored procedure - PSQL level language kept in the
database - but can be invoked as a function. That may appear in finite
time.


Regards,


Ann