Subject | Re: [firebird-support] Aggregate UDFs? |
---|---|
Author | Kjell Rilbe |
Post date | 2006-04-20T12:37:08Z |
Alan McDonald wrote:
example a concatenation of the values in a column:
select Concat_UDF(ITEM)
from STUFF
group by CATEGORY
Rather obscure, I know. Like I said, I was just curious.
Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
>>This is not something I need right now, but I'm curious: is it possibleYes, I mean that KIND of function, but assume you'd want to return for
>>to add aggregate functions as UDFs?
>>
>>If not, are there any plans to add support for this?
>
> Do you mean SUM(), AVG() etc? if so then they are already internal to the
> engine.
example a concatenation of the values in a column:
select Concat_UDF(ITEM)
from STUFF
group by CATEGORY
Rather obscure, I know. Like I said, I was just curious.
Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64