I would like to write a generic function that I can place as a BEFORE trigger
on several tables. It would do a max() on the column it was triggered for, and
return(max + 1) unless max returns a NULL, in which case it would return one.
Yes, I know this looks a lot like a sequence, but normally this value would
be provided manually at row input time, I just want to allow for some
automated updates.
The trick is hat the function needs to work for any numeric column I place it n
as a trigger.
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin