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.


--
  WBR, SD.


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to