Re: autoincrement??? - Mailing list pgsql-general

Hi,
try the serial type. This will create a sequence and add a default value to
collumn, which will auto increment your value.

Like:
 CREATE TABLE address (
          address_id serial  PRIMARY KEY ,
          street     VARCHAR(40),
          zipcode    INT,
          city       VARCHAR(40),
          country    VARCHAR(40)
 );

 INSERT INTO address VALUES('mainstreet 12', 85253, 'munich', 'Germany');

CoL:
col@econet.hu


Joshua Jore wrote:

> Huh, that's novel. I'd always written that as:
>
> INSERT INTO address VALUES (nextval('some_seq'), 'mainstreet 12', 85253,
> 'munich', 'Germany');
>
> where the difference is not using that extra 'SELECT' in the middle.
>
> Josh
>
> On Fri, 13 Jul 2001, Kevin Bullaughey wrote:
>
> > one way to do this is with a sequence.
> >
> > CREATE SEQUENCE some_seq MINVALUE 1;
> > CREATE TABLE address (
> >          address_id int  PRIMARY KEY ,
> >          street     VARCHAR(40),
> >          zipcode    INT,
> >          city       VARCHAR(40),
> >          country    VARCHAR(40)
> > );
> > INSERT INTO address VALUES(select nextval('some_seq'), 'mainstreet 12',
> > 85253, 'munich', 'Germany');
> >
> > in theory this should work but i didn't check it...it gives you the idea
> > anyway.
> >
> > -kevin
> >
> > --------------------------------------------
> > Kevin Bullaughey <kevin@gambitdesign.com>
> > Gambit Design Internet Services
> >
> > Integrated domain registration and
> >                     web-based DNS management
> >
> > --- http://www.gambitdesign.com/dns.html ---
> >
> >
> > > -----Original Message-----
> > > From: pgsql-general-owner@postgresql.org
> > > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Markus Jais
> > > Sent: Thursday, July 12, 2001 5:20 PM
> > > To: pgsql-general@postgresql.org
> > > Subject: [GENERAL] autoincrement???
> > >
> > >
> > > hi
> > > I have the following problem:
> > >
> > > I create the following table:
> > >
> > > CREATE TABLE address (
> > >         address_id int  PRIMARY KEY ,
> > >         street     VARCHAR(40),
> > >         zipcode    INT,
> > >         city       VARCHAR(40),
> > >         country    VARCHAR(40)
> > > );
> > >
> > > Now, I want the address_id to get incremented
> > > every time I insert a value into the table.
> > >
> > > for example:
> > > INSERT INTO address VALUES('mainstreet 12', 85253, 'munich', 'Germany')
> > > ;
> > > without specifying a value for the id.
> > >
> > > a friend told me, that this works in MySQL with something
> > > like "auto_increment". I do not know much about MySQL so I do not
> > > know if this is true.
> > >
> > > Can you please tell me, how to do this in postgresql????
> > >
> > > thanks a lot
> > > regards
> > > markus
> > >
> > > --
> > > Markus Jais
> > > http://www.mjais.de
> > > info@mjais.de
> > > The road goes ever on and on - Bilbo Baggins
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 3: if posting/reading through Usenet, please send an appropriate
> > > subscribe-nomail command to majordomo@postgresql.org so that your
> > > message can get through to the mailing list cleanly
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html