Re: serial field functionality

Posted in 1998

Mark D. Stock — Wed, 12 Aug 1998 20:44:32 +0200 — source: Informix-list mailing list archive (1991-1998)

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 won't. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+