Hello,
there is a table with a generated field called "Runde"

1
2
3
4
6    <====
7
....

there is after delete a whole.

I tried

ALTER TABLE zahlen
DROP COLUMN runde,
ADD COLUMN runde INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1)

that works perfect
but I got

...
7
6
5
4
3
2
1

what do I wrong....

TIA
Dieter

Dieter,

Why do you think something is wrong?
I can see nothing wrong here.
The value "5" is back again because the column "runde" was dropped and
when the column was re-added the values were generated again starting
with 0 with an increment of 1.
--
Fernando Dias
[Team Elevate]

Fernando,
the value is OK, but the order not.  The original was from 1 to... and the new is from .... to 1.


Thanks
Dieter














Fernando Dias <fernandodias.removthis@easygate.com.pt> wrote:

Dieter,

Why do you think something is wrong?
I can see nothing wrong here.
The value "5" is back again because the column "runde" was dropped and
when the column was re-added the values were generated again starting
with 0 with an increment of 1.
--
Fernando Dias
[Team Elevate]

Dieter,

have a look on the primary index of the table zahlen. It looks as if the new
column runde is ordered by using this primary index.

Uli

uli,
no the primary index is on "Datum"........


TIA
Dieter









"Uli Becker" <test@test.com> wrote:

Dieter,

have a look on the primary index of the table zahlen. It looks as if the new
column runde is ordered by using this primary index.

Uli

Dieter,

hard to help with no more informations about the table and the indexes.
Can you upload the table to the binaries?

Uli

Uli,
thanks. I have altered the table. I will try it later.

Many thanks for your help!

Dieter







"Uli Becker" <test@test.com> wrote:

Dieter,

hard to help with no more informations about the table and the indexes.
Can you upload the table to the binaries?

Uli