Tom Allison <tallison(at)tacocat(dot)net> writes:
> Can I use the serial data type in lieu of an 'auto_number' field?
What are the exact semantics of an "auto_number" field?
> I asked something like this some months ago and it seems that
> auto_number fields were addressed through a combination of triggers
> and procedures to ensure that there were do duplicate KEYS generated.
>
> Is it realistic to use the serial data type as a KEY?
Lots and lots of people do. If you're just looking for a unique key
column for a single table, it works fine.
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863