create or replace function plug_person8timerange (
	in the_day varchar,
	in id_employee integer
) returns setof plug_person8timerange
as $$
declare
	day varchar;
	sql varchar;
	rec record;
begin
	sql := 'select * from plug_person8timerange where ';
	if (id_employee is not null) then
		sql := sql || 'id_employee = ' || id_employee::varchar || ' order by the_day desc';
	else
		day := case when the_day is null then to_char(current_date, 'DD.MM.YYYY') else the_day end;
		sql := sql || 'the_day = \'' || the_day || '\' order by times_work desc';
	end if;
	for rec in execute sql loop
		return next rec;
	end loop;
	return;
end;
$$ language plpgsql;

create or replace function plug_person8timerange (
	in the_day varchar,
	in id_employee integer
) returns setof plug_person8timerange
as $$
declare
	day varchar;
begin
	if (id_employee is not null) then
		return query
		select		*
		from		plug_person8timerange p
		where		p.id_employee = id_employee
		order by	the_day desc
		;
	else
		day := case when the_day is null then to_char(current_date, 'DD.MM.YYYY') else the_day end;
		return query
		select		*
		from		plug_person8timerange p
		where		p.the_day = day
		order by	times_work desc
		;
	end if;
	return;
end;
$$ language plpgsql;

create or replace function plug_timeworktype (
	in pid integer,
	out id_work_type integer,
	out work_type varchar,
	out time_id integer
) returns setof record
as $$
declare
	key boolean;
begin
	key := true;

	return query
	select		wt.id_work_type,
			wt.work_type,
			wt.time_id
	from		С_Виды_работ wt
	where		wt.time_id =  12 
		or	wt.id_work_type =  22 
		or	(wt.id_work_type =  21  and key)
		or	(wt.id_work_type =  23  and (key or current_time < '13:30:00'))
	;
	return ;
end;
$$ language plpgsql;

select * from plug_timeworktype( 1631 )