List:General Discussion« Previous MessageNext Message »
From:Joerg Bruehe Date:September 18 2008 6:45am
Subject:Re: Finding gaps
View as plain text  
Hi !

Stut schrieb:
> On 17 Sep 2008, at 22:12, Jerry Schwartz wrote:
>> I have records that should be sequentially (not auto-increment) numbered,
>> but there are gaps. Is there any elegant way of finding the gaps?
> 
> Why do they need to be sequential? When this requirement comes up it's
> usually for illogical reasons.

I don't know his application,
but I do remember a similar requirement caused by some German rules on
bookkeeping which demanded that booking numbers were assigned without gaps.

That law may be illogical, but for the DB application designer this
doesn't help - s/he has no choice but to follow it.


Regards,
Jörg

-- 
Joerg Bruehe,  MySQL Build Team,  joerg@stripped
Sun Microsystems GmbH,   Sonnenallee 1,   D-85551 Kirchheim-Heimstetten
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering     Muenchen: HRB161028

Thread
Finding gapsJerry Schwartz17 Sep
  • Re: Finding gapsStut17 Sep
    • Re: Finding gapsPeter Brawley17 Sep
      • RE: Finding gapsJerry Schwartz8 Oct
        • Re: Finding gapsGerald L. Clark8 Oct
          • RE: Finding gapsUS Data Export8 Oct
        • Re: Finding gapsPeter Brawley8 Oct
          • RE: Finding gapsUS Data Export9 Oct
            • Re: Finding gapsPeter Brawley9 Oct
              • RE: Finding gapsJerry Schwartz10 Oct
                • Re: Finding gapsMoon's Father25 Oct
                  • Re: Finding gapsMoon's Father25 Oct
                  • RE: Finding gapsUS Data Export27 Oct
    • RE: Finding gapsJerry Schwartz17 Sep
      • Re: Finding gapsStut18 Sep
        • Re: Finding gapsMr. Shawn H. Corey18 Sep
        • RE: Finding gapsJerry Schwartz18 Sep
          • Re: Finding gapsMike Diehl18 Sep
            • RE: Finding gapsJerry Schwartz18 Sep
    • RE: Finding gapsMartin Gainty18 Sep
      • RE: Finding gapsJerry Schwartz18 Sep
    • Re: Finding gapsJoerg Bruehe18 Sep
    • Re: Finding gapsJoerg Bruehe18 Sep
      • Re: Finding gapsStut18 Sep
        • Re: Finding gapsMr. Shawn H. Corey18 Sep