I came as far as getting the first returned result by performing a SELECT INTO mytype function calculate_cost(...)...etc., which is normal I guess since a SELECT INTO only returns a single row according to the manual. However is there a way to loop / iterate all of the results?
SELECT INTO a variable will only get the first row of the returning rowset. To get the full rowset into a temporary table, you'll have to use INSERT INTO MYTEMPTABLE SELECT * FROM MYFUNCTION(), but working with temporary tables is never very pleasing in postgresql.
I recommmend you to iterate over the results by doing the following:
_t := 0; FOR _myrecord IN SELECT * FROM myfunction(...) LOOP _t := _t + _myrecord.mycolumn; END LOOP;
Cheers,
Ezequiel Tolnay
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
