Subject | Re: [firebird-support] Re: SUM and null values - Email found in subject |
---|---|
Author | Martijn Tonies |
Post date | 2011-11-27T12:48:53Z |
Hello Sean,
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!
>> > I was looking for a SQL expression, or maybe I need to create a UDF toFigured it was possible being something new, but apparently not yet. ;-)
>> > 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.
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!