---

CREATE SEQUENCE report.fns_vcht_number_sequence
    AS bigint
    INCREMENT BY 1
    MINVALUE 1
    CACHE 1;




SELECT setval(
    'report.fns_vcht_number_sequence',
    GREATEST(
        (
            SELECT serial_number::bigint
            FROM dev.unique_number
            WHERE code = 'smev_register'
        ),
        COALESCE(
            (
                SELECT max(number::bigint)
                FROM report.smev_register
                WHERE smev_register_type_code = 'ФНС-ВЧТ'
                  AND number ~ '^[0-9]+$'
            ),
            0
        )
    ),
    true
);




select last_value
from report.fns_vcht_number_sequence;


registrationNumberSequence: "report.fns_vcht_number_sequence"




SELECT setval(
    'report.fns_vcht_number_sequence',
    GREATEST(
        (
            SELECT last_value
            FROM report.fns_vcht_number_sequence
        ),
        CAST(:new_number AS bigint)
    ),
    true
);