Finding missing integers

Posted in 1996

Joseph Arcieri — 16 Feb 1996 09:09:01 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi, I'm not sure how to do this. I'm running SQL v4/SE v5 and have several databases that use an integer field as the record id. Is there a way to find skipped or unused integers in the field? e.g. Each row that's added has a unique number added automatically, but when rows are deleted, those numbers are available to be used again. How can I search for used numbers/integers in a range? Make senes?possible? Thanks, Joe Arcieri