Re: Best approach for a "gap-less" sequence

From: Jorge Godoy <jgodoy(at)gmail(dot)com>
To: Harald Fuchs <hf0731x(at)protecting(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Best approach for a "gap-less" sequence
Date: 2006-08-14 16:37:28
Message-ID: 87zme7uvcn.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Harald Fuchs <hf0731x(at)protecting(dot)net> 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 <jgodoy(at)gmail(dot)com>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2006-08-14 17:07:20 Re: problem with a dropped database
Previous Message Richard Broersma Jr 2006-08-14 16:28:36 Re: Best approach for a "gap-less" sequence