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

From: Harald Fuchs <hf0731x(at)protecting(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Best approach for a "gap-less" sequence
Date: 2006-08-14 20:23:32
Message-ID: pu3bbzf4mz.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <C1061F94(dot)52761%scott_ribe(at)killerbytes(dot)com>,
Scott Ribe <scott_ribe(at)killerbytes(dot)com> writes:

>> Why putting gapless numbers into the database at all? Just
>> calculate them at query time.

> There is ABSOLUTELY NO WAY that would be acceptable for accounting or legal
> purposes. It would be the same as fabricating the numbers during an audit.

At some point in time those numbers "get fabricated" anyway. As long
as you don't change the records inbetween, the technical effect would
be the same. But you might be right that this is forbidden. I don't
speak legalese.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jorge Godoy 2006-08-14 20:26:19 Re: Best approach for a "gap-less" sequence
Previous Message Harald Fuchs 2006-08-14 20:19:44 Re: Best approach for a "gap-less" sequence