test=# select PLpgSQLDepartmentSalaries() ;
This should be: regression=# select * from PLpgSQLDepartmentSalaries(); departmentid | totalsalary --------------+------------- 1 | 80000 2 | 60000 (2 rows)
HTH,
Joe
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org