Re: [SQL] Sequence vs Serial

2007-04-01 Thread Tom Lane
Scott Marlowe <[EMAIL PROTECTED]> writes: > Daniel CAUNE <[EMAIL PROTECTED]> Said: >> I was wondering when it is better to choose sequence, and when >> it is better to use serial. > One reason for using serial versus sequence is that a serial gives you > automatic dependency tracking. Note that

Re: [SQL] Sequence vs Serial

2007-04-01 Thread Scott Marlowe
Daniel CAUNE <[EMAIL PROTECTED]> Said: > I was wondering when it is better to choose sequence, and when > it is better to use serial. The serial type is a sequence with > default parameters (http://www.postgresql.org/docs/8.2/static/datatype-numeric.html#DATATYPE-SERIAL). > Actually, I never