Re: Hi there, new here and have question

[Asche <asche.public@xxxxxxx>]

> Any suggestion everyone?
Sorry, i was to fast sending this email out ;-)

change the first parameter in the first line to '_id_depth'

CREATE OR REPLACE FUNCTION  listofemployeebasedondepartment(_id_dept  
int)
 RETURNS SETOF employee AS
$BODY$
BEGIN

 RETURN QUERY
     SELECT
         *
     FROM
         employee
     WHERE
         id_dept = _id_dept;

 RETURN;
END;
$BODY$
 LANGUAGE 'plpgsql';

Jan