Re: Integrating the field auto-increment

On 1 Aug 2003, Dave Cramer wrote:

> create table foo ( id serial )

Note that as of 7.3, the serial type is no longer declared unique, so you
may want to add that keyword to your declaration nowadays if you also want
a unique index constraint:

create table foo (id serial unique);

>
> Dave
> On Fri, 2003-07-25 at 11:07, thomas(dot)mathes(at)tmnd(dot)de wrote:
> > Hello,
> >
> > How can I implement an integer field with the autoincrement option ?
> > That means I want to have a field, where every row has different values
> > (unique) but this values should be generated automatically.
> > Every new row has a new value, which is 1 higher than the old one.
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faqs/FAQ.html
> >
>