check constraint on insert but not delete - Mailing list pgsql-general

This is a longshot, but here goes...

Is there a way to require that a check constraint be checked on insert but not update?    Worth knowing is that my check constraint runs a PLPgsql proc which returns a yes/no kinf of flag which the constraint proper checks.

Thanks !