Subject | Re: [firebird-support] View limitations |
---|---|
Author | Ivan Prenosil |
Post date | 2007-08-14T22:53:30Z |
Alexandre,
SELECT Exp( SUM( Ln(x) ) ) FROM ...
Ivan
http://www.volny.cz/iprenosil/interbase/
> I post a message on fb-architect about an aggregate function thatPerhaps you can add UDFs for logarithm and exponential functions and do this:
> 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 :-)
SELECT Exp( SUM( Ln(x) ) ) FROM ...
Ivan
http://www.volny.cz/iprenosil/interbase/