Subject RE: [firebird-support] Stored Procedure strange behaviour
Author Alan McDonald
> Thanks Alan.
> What this means: "the deleted records will not change the order of the
> PK fields"? Shouldnt PK fields get updated at indexes as soon as they
> have new values?
> Regards

once a record is deleted, the value of the PK is gone. The index will, of
course be updated, but the order of the records does not change (barring the
now omitted record).
i.e. before delete, PK values 1, 2, 3, 4, 5, 6 etc. Now delete record PK=3.
new order is 1, 2, 4, 5, 6 etc i.e. the order has not changed.