from warehouse

    where goods_id = NEW.goods_id;

if whcount < NEW.count then

--записываем сообщение о нехватке товара

    insert into goods_warnings(goods_id, message, date)

           values(NEW.goods_id,

'Недостаточно на складе', now());

--проверяем, есть ли просроченные

    select count(count), sum(count) into rsorders, rscount

           from reserved

           where goods_id = NEW.goods_id and

                 date < now() - '5 day'::interval;

    if rscount + whcount >= NEW.count then

--отменяем просроченный заказ

           for row in select * from reserved where

date < now() - '5 days'::interval loop

                 update orders set status = 'cancelled'

                        where order_id = row.order_id;

                 delete from reserved

where order_id = row.order_id;

                 insert into orders_warnings(order_id,

message, date)

                        values(row.order_id,

'Заказ отменен', now());

           end loop;

--делаем новую запись в таблицу резерва

           insert into reserved(order_id, goods_id, count, date)

                 values(NEW.order_id, NEW.goods_id,

NEW.count, NEW.date);