Hello
I have a table created as the following
CREATE TABLE mod48_00_2007
(
id text,
n_gen serial NOT NULL,
formstore text,
te_cognome text,
te_paternita text,
te_nome text,
te_sesso text,
te_dtnasc text,
te_attnasc text,
te_luonasc text,
te_provstato text,
te_indi text,
te_prov text,
te_richiesta text,
atto_forma text,
rev_test text,
atto_dt text,
atto_num text,
dt_olog text,
cod_notaio text,
pa_cognome text,
pa_nome text,
pa_qual text,
pa_indirizzo text,
pa_civ text,
pa_cap text,
pa_pro text,
pa_sede text,
pa_estero text,
pa_data text,
f_olo text,
f_pub text,
f_rev text,
f_seg text,
f_spe text,
atto_riferimento text,
ratto_dt text,
ratto_num text,
rdt_olog text,
r_cognome text,
r_nome text,
r_qual text,
r_sede text,
r_estero text,
dt_oggi text,
n_pub_aut text,
dt_tr_rgt text,
sche_singola text,
sche_multipla text,
n_fog text,
tot_n_fog text,
reg_anno text,
username text,
date_inserted text,
time_inserted text,
deleted text,
date_deleted text,
time_deleted text,
f_tes text,
CONSTRAINT mod48_00_2007_pkey PRIMARY KEY (n_gen)
)
At a surtain point i need to replace a record with another
For example i have inserted 4 records. (1, 2 , 3 , 4) I need to replace all the values from the record 4 to the record 2 but keeping the n_gen serial key. And then delete the record 4. So that the next record i insert will take the n_gen 4
How can i do this?
Shavonne Wijesinghe
