Could anyone tell me what I'm doing wrong here?
I have a table, that does indeed contain data:
SELECT last_name, first_name, email, department, salary from employees
where department='Engineering';
returns 4 rows.
I've also tried to define a function that should return a table:
CREATE OR REPLACE FUNCTION get_employees_for_department(IN
the_department character varying)
RETURNS TABLE(last_name character varying, first_name character
varying, email character varying, department character varying, salary
numeric) AS
$BODY$
begin
return query SELECT last_name, first_name, email, department, salary
from employees where department=the_department;
end
$BODY$
LANGUAGE plpgsql;
However, when I try using that function:
select * from get_employees_for_department('Engineering');
No rows are returned.
Regards
Richard