Re: auto_increment
| От | Muhyiddin A.M Hayat |
|---|---|
| Тема | Re: auto_increment |
| Дата | |
| Msg-id | 002201c37f54$29608e40$1f00a8c0@middinkcomp обсуждение исходный текст |
| Ответ на | auto_increment ("Muhyiddin A.M Hayat" <middink@indo.net.id>) |
| Ответы |
Re: auto_increment
Re: auto_increment |
| Список | pgsql-sql |
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 по дате отправления: