Subject Re: [firebird-support] Re: little help to build a query in Firebird
Author Ann Harrison
2011/9/8 Svein Erling Tysvær <svein.erling.tysvaer@...>

> > ... resetting a generator leaves
> > no traces and can be done as often as you wish.
>
> The implementation of generators (aka sequences) is very simple, There's a
table, RDB$GENERATORS that holds the generator name and it's ID. The id is
an index into the array of generators. Generators are stored on special
database pages which have a header and a chunk of the array. Each element
in the array is a 64 bit integer. When the value of a generator is changed,
whether by incrementing it or resetting it, the value in the array entry
changes. Nothing counts the number of changes.

Good luck,

Ann


[Non-text portions of this message have been removed]