CREATE TYPE my_type (
	subgroup_number int,
	subgroup_count int,
	week_split int,
	les_type int,
	notice char, 
	elective_course int,
	kind_of_department int,
	full_name char,
	subject char,
	number_rooms char,
	semestre int
 );

CREATE OR REPLACE FUNCTION getLessonInfo(day_of_week int,
					number_pair int,
					number_course int,
					number_group int
					) 
RETURNS my_type 
AS 
$$

DECLARE
  result_record my_type;

BEGIN

	select l.subgroup_num,l.subgroup_count, l.week_split, l.les_type, l.notice, l.elective_course, 	l.kind_of_department,t.full_name, sub.subject, prs.rooms, l.semester
	
	into result_record.subgroup_number, result_record.subgroup_count, result_record.week_split, result_record.les_type, result_record.notice, result_record.elective_course, result_record.kind_of_department, result_record.full_name, result_record.subject, result_record.number_rooms, result_record.semestre

	from lessons l, curriculum c, study_groops s, subjects sub, teachers t, lesson_time les, select_class_set prs
	where l.days= day_of_week and les.less_num = number_pair and s.course_num = number_course and s.group_num =number_group and s.id = c.study_group_id and sub.id = c.subject_id and t.id = c.teacher_id and c.id = l.curriculumid and les.id = l.lesson_time_id and l.classroom_set_id = prs.id



  RETURN result_record;

END
$$ LANGUAGE plpgsql; 

CREATE TYPE my_type AS (…