Annotation: transactions.get_new_transaction_counter

Information: transactions.get_new_transaction_counter

Implementation: transactions.get_new_transaction_counter

CREATE OR REPLACE FUNCTION transactions.get_new_transaction_counter(date)
 RETURNS integer
 LANGUAGE plpgsql
AS $function$
    DECLARE _ret_val integer;
BEGIN
    SELECT INTO _ret_val
        COALESCE(MAX(transaction_counter),0)
    FROM transactions.transaction_master
    WHERE value_date=$1;

    IF _ret_val IS NULL THEN
        RETURN 1::integer;
    ELSE
        RETURN (_ret_val + 1)::integer;
    END IF;
END;
$function$