On 01/10/2018 07:28, Dimitry Sibiryakov wrote: > 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. > > Saying that aggregate functions should return more than one data with a feature different than ROW type, is like saying our function (and any language's function) is broken.
This is highly non-sense. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel