Re: Sequences part 2

2019-07-02 Thread Thomas Kellerer
Karl Martin Skoldebrand schrieb am 02.07.2019 um 13:20: >>> Now I want to insert more countries, between France and Ireland. >> >> That is a wrong assumption - there is no "between" for rows in a >> relational database. >> > > Yes, I'm fairly aware of this. However the application the > databas

RE: Sequences part 2

2019-07-02 Thread Karl Martin Skoldebrand
> Yes, I'm fairly aware of this. However the application the database table > belongs to seems to rely on a specific order in the database. I.e. if I just > add value to the table they end up, possibly due to how the application is > coded in an undesireable spot on the web page. > That is why

Re: Sequences part 2

2019-07-02 Thread Karsten Hilbert
On Tue, Jul 02, 2019 at 11:20:42AM +, Karl Martin Skoldebrand wrote: > Yes, I'm fairly aware of this. However the application the database table > belongs to seems to rely on a specific order in the database. I.e. if I just > add value to the table they end up, possibly due to how the applic

RE: Sequences part 2

2019-07-02 Thread Karl Martin Skoldebrand
Karl Martin Skoldebrand schrieb am 02.07.2019 um 12:44: > Looking more at sequences, I have some sequences that start with ID 1, > incrementing each record by 1. > > So I have e.g. 1 Spain 2. Germany 3. France 4. Ireland 5. Norway > > Now I want to insert more countries, between France and Irela

Re: Sequences part 2

2019-07-02 Thread Thomas Kellerer
Karl Martin Skoldebrand schrieb am 02.07.2019 um 12:44: > Looking more at sequences, I have some sequences that start with ID 1, > incrementing each record by 1. > > So I have e.g. 1 Spain 2. Germany 3. France 4. Ireland 5. Norway > > Now I want to insert more countries, between France and Irela