Tom Allison <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster