From: | richard(at)xentu(dot)com |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | function returns no results |
Date: | 2015-12-05 18:03:52 |
Message-ID: | 6030d35333971e0a4efa7def4d55d37a@xentu.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2015-12-05 18:23:54 | Re: function returns no results |
Previous Message | Albe Laurenz | 2015-12-04 14:14:41 | Re: Compiling with Visual C++ |