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
> 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
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
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
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
Thanks for replies.
I looked at some tutorial page and there were more instructions in that, so got
confused. I was aware sequences create integers.
//Martin S
Disclaime
There's nothing really "in" a sequence, it just generates numbers for
you, generally for unintelligent primary keys. Those statements
perfectly create new sequences which will start from 1.
Tim Clarke
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420
On 24/06/2019 10:01, Karl
Hi Karl
I did not double check with the doc whether the SQL you posted is
valid (I guess it could by applying the defaults) however I do not see
how sequences would govern the sending of data to users.
Kind regards
Thiemo
Quoting Karl Martin Skoldebrand :
Hi,
I'm trying to troubleshoot
