question on serial key
| От | Brandon Metcalf |
|---|---|
| Тема | question on serial key |
| Дата | |
| Msg-id | Pine.LNX.4.58L.0905220831390.8880@cedar.geronimoalloys.com обсуждение исходный текст |
| Ответы |
Re: question on serial key
Re: question on serial key |
| Список | pgsql-general |
This may be better discussed in the pgsql-sql forum. Please let me know if so. I am looking for criteria on deciding whether or not to use a serial (auto-incrementing) key for rows in a table. For example, if I have a table of, say, the elements on the periodic table I could use the atomic number as a unique key which would not be a serial type. Another example is where I'm inserting lots of rows in a given period of time and I need to go back and select the max id of one of these rows; I would need a serial key in this case. Intuitively, it's pretty clear to me when a serial index is called for. Is there a succinct set of guidelines that one could go by? Thanks. -- Brandon
В списке pgsql-general по дате отправления: