automatic incrementation
От | Nuchanard Chiannilkulchai |
---|---|
Тема | automatic incrementation |
Дата | |
Msg-id | 375E2A1D.FC614366@valigene.com обсуждение исходный текст |
Список | pgsql-sql |
hello, I have a table with the field 'id' which i would like to increment at each insert automatically. The idea is to create a function which determines the max(id) and then a rule to insert instead the real insertion instruction, with the next id value. -- table create table toto ( id int4 primary key, project char(8) not null, comments text ); insert into toto values (1,'PTest','ndfjSHJG'); insert into toto values (2,'PTest','ndfjSHJG'); insert into toto values (3,'PTest','ndfjSHJG'); -- function create function nextid(toto) returns int4 as ' select max($1.id)+1 as id ; ' language 'sql'; **** ERROR: type id lookup of 12 failed This is my first problem -- rule create rule r_id as on insert to toto do instead insert into toto (id, project, comments) values (nextid(), new.project, new.comments); **** The next problem may be the rule writing !!! I would like to have , even some other suggestions to make it works. I can't use a sequence table because I've already one in the database. Thanks, Nuch
В списке pgsql-sql по дате отправления: