Harald Fuchs <[EMAIL PROTECTED]> writes: > Why putting gapless numbers into the database at all? Just calculate them at > query time.
And how would you retrieve the record that corresponds to invoice number #16355, for example? Recalculating few records is fine, but millions of them everytime you need to recover some of those is something that doesn't look efficient to me... -- Jorge Godoy <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend