Dimitry Sibiryakov <s...@ibphoenix.com> wrote Mon, 01 Oct 2018 13:28:44
+0300:
01.10.2018 12:22, Simonov Denis via Firebird-devel wrote:
Current SPs do not know how to aggregate data by an external cursor. To
do this, you need to write queries inside the SP.
How is this related to (in)ability to return several values at once?
create aggregate function custom_avg (i double precision) returns (o
double precision, dev double precision) as .....
select custom_avg(x) from t; <-- this query can return two fields w/o
any problem no matter how the function access input data.
Dmitry, do not go beyond the context of the discussion. Here, user-defined
aggregate functions are discussed. None of the built-in aggregate
functions can do this either. And yes, you did not give an example of how
this should look for universal stored aggregation procedures.
--
Simonov Denis
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
