In some table, I have a bigint column which at the app level can be
null. Call it "DocumentNumber", and of course is not the PK.
In most cases, the applications give some value to the column.
But sometimes, the value remains null, expecting the backend or someone
assign it a unique value.
Could I use a sequence only when the field arrives to the backend as
null? How? Using a triger?
Alternatively:
How could I get the max value for the column and increment it by one,
but with concurrency warranty? Something as a table lock?
TIA