Subject Re: [firebird-support] View limitations
Author Ivan Prenosil
Alexandre,
> I post a message on fb-architect about an aggregate function that
> multiplies the column values instead of summing it up.
>
> This request could be done using a selectable SP, but I need it working
> inside views, as you know UDF's is not an option for aggregates, so I
> have a problem :-)

Perhaps you can add UDFs for logarithm and exponential functions and do this:

SELECT Exp( SUM( Ln(x) ) ) FROM ...

Ivan
http://www.volny.cz/iprenosil/interbase/