Re: serial field functionality

Bill Weaver wrote: > > I believe I already know the answer to this but I thought I'd ask the "community at large" to > make sure. I have a serial field in a table. That table has several "holes" in the numbers do > to things like deletions. If I reset the starting serial value for the table, will it use the > values for the "holes" and skip over existing values? There is a long, sad, sordid story behind > why I need to do something like this so I won't burden you with the details! No it will reset itself to max(column)+1 during the first insert. I'll return the favor and not bore you with the details, but you can probably solve you problem if you let us risk accepting the burden. Art S. Kagel