Re: Hi there, new here and have question

> 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