Subject | RE: [firebird-support] Aggregate UDF? |
---|---|
Author | Alan McDonald |
Post date | 2010-06-24T02:15:58Z |
>still not sure what you think is missing.
> On Wed, Jun 23, 2010 at 5:42 PM, Alan McDonald <alan@...>
> wrote:
> >
> > FB has inbuilt aggregate functions.
> > It also supports UDFs
> > You need to explain more about what you think is missing.
>
> 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.
>
> Cartoper
>
You can write your own UDFs.
There are some built-in functions which can assist you in things like STD.
You are asking if FB supports aggregate functions. The answer is yes.
It supports UDFs of your own making if the built-in ones are insufficient.
if you are, on the other hand, asking if FB supports whatever function/UDF
library you are currently using in SQLite, then I can't help since I don't
know what they are.
Alan