Re: autoincremental field

Posted in 2000

Martin A. Marques — Wed, 21 Jun 2000 16:59:07 -0300 (ART) — source: Informix-list mailing list archive (1991-1998)

On Wed, 21 Jun 2000, Arnaud ANDRIEUX wrote: > Change to SERIAL type and create a unique index on this column to ensure > that you will have unique values. SERIAL type has the same range that > INTEGER type. Those serial keep uniqueness, or do I have to force it? ----------------------------------------------------------------- Mart'n Marqu's email: martin@math.unl.edu.ar Santa Fe - Argentina http://math.unl.edu.ar/~martin/ Administrador de sistemas en math.unl.edu.ar -----------------------------------------------------------------

↪ replying to Martin A. Marques

Nick Kataria — Wed, 21 Jun 2000 13:52:27 -0700 — source: Informix-list mailing list archive (1991-1998)

Martin A. Marques <martin@math.unl.edu.ar> wrote in message news:8ir9mc$h4p$1@news.xmission.com... > > On Wed, 21 Jun 2000, Arnaud ANDRIEUX wrote: > > > Change to SERIAL type and create a unique index on this column to ensure > > that you will have unique values. SERIAL type has the same range that > > INTEGER type. > > Those serial keep uniqueness, or do I have to force it? You have to force the uniqueness by creating unique index on SERIAL column. > > > > ----------------------------------------------------------------- > Mart'n Marqu's email: martin@math.unl.edu.ar > Santa Fe - Argentina http://math.unl.edu.ar/~martin/ > Administrador de sistemas en math.unl.edu.ar > ----------------------------------------------------------------- >