Subject Re: [firebird-support] Re: SUM and null values - Email found in subject
Author Martijn Tonies
Hello Sean,

>> > I was looking for a SQL expression, or maybe I need to create a UDF to
>> > do some thing like:
>> >
>> > SELECT SUM_EX(Age) FROM Persons
>> >
>> >
>> > In any case, thank you for your prompt reply.
>>
>> Are UDFs on groups of records even possible?
>
> I am pretty sure you have deliberately asked a rhetorical question (given
> how long you have been using IB/FB).
>
> Aggregate UDF functions are NOT possible.

Figured it was possible being something new, but apparently not yet. ;-)

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!