RE: autoincrement???

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