CREATE OR REPLACE FUNCTION public.easy_pay(integer, integer)
 RETURNS integer
 LANGUAGE plpgsql
AS $function$DECLARE
  user_id ALIAS FOR $1;
  amount ALIAS FOR $2;
  user record;
  mg record;
  newbalance float;
BEGIN
  SELECT INTO user es.balance as esbalance
              from
                  easy_users es
              where
                  es.usid = user_id;

  IF NOT FOUND THEN
    RAISE EXCEPTION 'Cannot find user';
    return -2;
  END IF;

  IF user.esbalance < amount THEN
        return -1;
  END IF;
  newbalance     := user.esbalance - amount;
  UPDATE easy_users SET balance = newbalance
                  WHERE usid = user_id;  
  return 1;
END;$function$