On 9/25/19 10:12 PM, Matthias Apitz wrote:
El día miércoles, septiembre 25, 2019 a las 07:42:11a. m. -0700, Adrian Klaver
escribió:
sisis$# DECLARE
sisis$#maxikatkey integer := ( select max(katkey) from titel_daten );
sisis$#result integer := 1;
sisis$# BEGIN
sisis$#maxikatkey := m
El día miércoles, septiembre 25, 2019 a las 07:42:11a. m. -0700, Adrian Klaver
escribió:
> >>> sisis$# DECLARE
> >>> sisis$#maxikatkey integer := ( select max(katkey) from titel_daten );
> >>> sisis$#result integer := 1;
> >>> sisis$# BEGIN
> >>> sisis$#maxikatkey := maxikatkey +1;
>
On 9/24/19 10:40 PM, Matthias Apitz wrote:
El día martes, septiembre 24, 2019 a las 08:01:46a. m. -0700, Adrian Klaver
escribió:
On 9/24/19 7:47 AM, Matthias Apitz wrote:
Hello,
We have in a database some 400 tables, 75 of them have a 'serial'
column, like the one in the example table 'tite
El día martes, septiembre 24, 2019 a las 08:01:46a. m. -0700, Adrian Klaver
escribió:
> On 9/24/19 7:47 AM, Matthias Apitz wrote:
> >
> > Hello,
> >
> > We have in a database some 400 tables, 75 of them have a 'serial'
> > column, like the one in the example table 'titel_daten', column 'katkey'
On 9/24/19 7:47 AM, Matthias Apitz wrote:
Hello,
We have in a database some 400 tables, 75 of them have a 'serial'
column, like the one in the example table 'titel_daten', column 'katkey'.
I want to create a SQL script to adjust alls these sequences to the
max+1 value in its column after loadi
Hello,
We have in a database some 400 tables, 75 of them have a 'serial'
column, like the one in the example table 'titel_daten', column 'katkey'.
I want to create a SQL script to adjust alls these sequences to the
max+1 value in its column after loading the database from CSV file.
I found no o
