function returns no results
От | richard@xentu.com |
---|---|
Тема | function returns no results |
Дата | |
Msg-id | 6030d35333971e0a4efa7def4d55d37a@xentu.com обсуждение исходный текст |
Ответы |
Re: function returns no results
|
Список | 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
В списке pgsql-novice по дате отправления: