Hi,
I have a question on the right/correct practice on using the serial col's sequence for insert.
Best way of explanation is by an example:
create table id01 (col1 serial, col2 varchar(10));
insert into id01(col2) values ( 'data'||currval('id01_col1_seq')::varchar);
insert into id01(col2) values ( 'data'||currval('id01_col1_seq')::varchar);
while I do get what I want:
select * from id01;
col1 | col2
------+-------
1 | data1
select * from id01;
col1 | col2
------+-------
1 | data1
Is this guaranteed to work : I am assuming that an insert triggers the id01_col1_seq's nextval first hence using
id01_col1_seq's currval subsequently will have the "correct" / expected value (and not the previous value before the insert).
id01_col1_seq's currval subsequently will have the "correct" / expected value (and not the previous value before the insert).
Is my assumption correct?
Thanks in advance,
AK
