> I thought about using a DEFAULT value, but I had presumed > that this was only for repeated intializations. So then is it the > case that a > CREATE TABLE mytable ( id INTEGER PRIMARY KEY DEFAULT 100000, ... > only applies this default to the very first row of such a table, and then > sensibly, increments from there ? > (Guess I could easily try this out...) Ah, I think I know what you are looking for. You want an auto-incrementing number. There are special sudo-data-types called serial bigserial. These are really auto-incrementing integers/bigintegers. For more details on how to use this see: http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-SERIAL Also, when relying, don't forget to reply also to the list that way everyone can participate. Regards, Richard Broersma Jr.
