I'm struggling to find out whether there is a constraint I can impose on a row with an integer value, such that any update on that row must have an integer value strictly greater than the value that already exists in the table.

Do I need to use a trigger to do this, or is there a clever way to use constraints to do this?

Note, I don't want a serial type since I do not want it to autoincrement.

  • 3
    I don't think this can be expressed with a constraint. You will have to use a trigger
    – user1822
    Mar 15, 2023 at 6:11


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.