Re: auto_increment
От
Muhyiddin A.M Hayat
Тема
Re: auto_increment
Дата
Msg-id
002201c37f54$29608e40$1f00a8c0@middinkcomp
Список
Дерево обсуждения
Re: auto_increment Christopher Browne <cbbrowne@acm.org>
Ok, but if i do rollback, the auto_increment don't roolback.
How to use nextval(), currval() and setval() functions.
----- Original Message -----
From: Cavit KeskinSent: Saturday, September 20, 2003 2:15 PMSubject: RE: [SQL] auto_incrementCreate 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
В списке pgsql-sql по дате отправления