Re: [GENERAL] Best approach for a "gap-less" sequence

[AgentM]

Since the gapless numbers are purely for the benefit of the tax  
people, you could build your db with regular sequences as primary  
keys and then regularly (or just before tax-time) insert into a table  
which maps the gapless sequence to the real primary key.

-M


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend