Skip site navigation (1) Skip section navigation (2)

going crazy with serial type

From: Cindy <ctmoore(at)uci(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: going crazy with serial type
Date: 2002-01-31 19:40:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
OK.  My background is in mysql, and I've been converting over to psql.  Just
by way of background.

I do !NOT! understand how the SERIAL type works.  I want something
like I had in mysql that would generate new, unique numbers, each time
I added a new record.  I want something that sits down, shuts up, and
just GIVES me the number on demand.  (I also want a guarantee that the
unique number is consecutive, and is never zero or negative.)  In short,
I want the AUTO_INCREMENT behavior.

But so far it's been one giant headache.  Tell me, how do I insert
new records into a table *without* specifying an actual number?  In
mysql it's just an empty field.  I have been unable to determine how
to do this in psql other than to ascertain it certainly isn't through
the same way.

I've been through the documentation, but for some reason, no one seems
to think a programmer would ever want functionality like mysql's
AUTO_INCREMENT, so as far as I can tell, it's not even addressed.

I'd appreciate any help.  I basically have a table:

create table mytable (mytable_id serial, a int, b int);


insert into mytable ('', 1, 2); is accepted but then following
insert into mytable ('', 5, 6); etc, is rejected due to "duplicate key"



pgsql-general by date

Next:From: Andrew SullivanDate: 2002-01-31 19:49:03
Subject: Re: Function to Pivot data
Previous:From: Gregory WoodDate: 2002-01-31 19:35:19
Subject: Re: unique & update

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group