Re: sequence omits numbers?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 05 Aug 2003 21:15:33 +0200
Message-ID: <9h00jvkacngh2uf6l22qj0roc02uaqlhdj@4ax.com>

On Tue, 05 Aug 2003 16:26:43 +0200, Stefan Röhle <roehle_at_uni-mainz.de> wrote:

>But traditionally (and I cannot change that) we use numbers composed of
>a special scheme and certain number ranges indicate some properties
>connected with it (e.g. numbers between 1 and 199 indicate that those
>invoices return every year, numbers between 200 and 2999 are for general
>purposes etc.).
>So I have to make sure that they do not leave the intervals which can
>happen if there are many missing numbers.

So you now have hit the reason NOT to do that, and separate those 'meaningful' numbers in separate columns.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Aug 05 2003 - 14:15:33 CDT