CREATE FUNCTION s_faculty_f(v_id INTEGER)
	RETURNS TABLE (faculty_id INTEGER,
				   full_name VARCHAR( 200 ),
				   abbreviation VARCHAR( 10 ),
				   head VARCHAR( 90 ))
	DETERMINISTIC
	NO EXTERNAL ACTION
------------------------------------------------------------------------
-- SQL Пользовательская функция
------------------------------------------------------------------------
BEGIN 

	IF v_id = - 1  
	THEN
		RETURN 
		-- Выборка всех значений из таблицы
		SELECT faculty_id,
               full_name,
               abbreviation,
               head
  		FROM faculty;
  	ELSE
  		RETURN 
  		-- Выборка значений по v_id из таблицы	
		SELECT faculty_id,
               full_name,
               abbreviation,
               head
  		FROM faculty
  		WHERE faculty_id = v_id;
	END IF;
END