going crazy with serial type
От | Cindy |
---|---|
Тема | going crazy with serial type |
Дата | |
Msg-id | 6387.1012506056@attalus.tlg.uci.edu обсуждение исходный текст |
Ответы |
Re: going crazy with serial type
Re: going crazy with serial type Re: going crazy with serial type Re: going crazy with serial type Re: going crazy with serial type |
Список | 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); and insert into mytable ('', 1, 2); is accepted but then following insert into mytable ('', 5, 6); etc, is rejected due to "duplicate key" Thanks, --Cindy -- ctmoore@uci.edu
В списке pgsql-general по дате отправления: