Ok, but if i do rollback, the auto_increment don't roolback.
How to use nextval(), currval() and setval() functions.
----- Original Message -----
From: Cavit Keskin
To: 'Muhyiddin A.M Hayat'
Sent: Saturday, September 20, 2003 2:15 PM
Subject: RE: [SQL] auto_increment
Create table tablename(
id serial,
....
);
Serial type is integer and autoincrement
When you create this table creates automatic sequence tablename_id_seq
Stored sequence last value;
Try execSQL : select * from tablename_id_seq;
My english is very very little and bad