-- Function: get_employer_fio(bpchar, integer)

-- DROP FUNCTION get_employer_fio(bpchar, integer);

CREATE OR REPLACE FUNCTION get_employer_fio(pc_employerid bpchar, pi_typename integer)
  RETURNS character varying AS
$BODY$ 
/*
Возврат - СТРИНГ - EmployerFIO по входной pc_employerid
флаг pi_typename указывает на то, как будут представлены: 
	0 - И.О.
	1 - Имя Отчество
*/       

  DECLARE cReturn VARCHAR( 60 );
BEGIN 
    SELECT RTRIM(e.Family)||' '||
		CASE WHEN pi_typename= 0  THEN substring(e.FirstName, 1 , 1 )||'.' ELSE RTRIM(e.FirstName) END ||
		CASE  WHEN e.LastName IS NOT NULL  THEN 
			CASE WHEN pi_typename= 0  THEN substring(e.LastName, 1 , 1 )||'.' ELSE RTRIM(e.LastName) END ELSE '' END INTO cReturn
    FROM Employer e
   WHERE e.EmployerID=pc_employerid;
   IF cReturn IS NULL THEN
		cReturn:='';
   END IF;
   RETURN cReturn;
END$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST  100 ;
ALTER FUNCTION get_employer_fio(bpchar, integer) OWNER TO postgres;
GRANT EXECUTE ON FUNCTION get_employer_fio(bpchar, integer) TO public;
GRANT EXECUTE ON FUNCTION get_employer_fio(bpchar, integer) TO postgres;
GRANT EXECUTE ON FUNCTION get_employer_fio(bpchar, integer) TO "ctuUserRole";