I have a table with staff member data. For obligatory historic
reasons, each staff member has a unique number assigned, which is
taken as primary key. For the same historic reasons the list of staff
numbers is not complete, i.e. there are gaps inbetween. When a new
staff member is introduced, I want to assign the lowest free number to
him or her. How can I find the lowest free integer primary key using
(staff_number, ...some more staff member information left off)
The lowest free staff_number is 3. Is it possible ...