Re: [SQL] auto_increment

[Muhyiddin A.M Hayat]

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