Andreas Tille wrote:> test=# select PLpgSQLDepartmentSalaries() ;
This should be:regression=# select * from PLpgSQLDepartmentSalaries(); departmentid | totalsalary--------------+------------- 1 | 80000 2 | 60000(2 rows)
HTH,
Joe