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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
