SERIAL data type
От | t-ishii@sra.co.jp (Tatsuo Ishii) |
---|---|
Тема | SERIAL data type |
Дата | |
Msg-id | 199809120125.KAA05600@meshsv26.tk.mesh.ad.jp обсуждение исходный текст |
Ответы |
Re: [HACKERS] SERIAL data type
Re: [HACKERS] SERIAL data type |
Список | pgsql-hackers |
A few questions for new SERIAL data type: o dropping a table including a serial data type does not drop the sequence corresponding to the table. This prevents re-creating the table. Do we have to remove the sequence by hand? o explicit insertion to the serial column sets the value specified. This is good. However, next implicit insertion results in that previous value from the sequence + 1 is set. create table t (c text, i serial); insert into t values('a'); insert into t values('b',100); insert into tvalues('c'); select * from t; a 1 b 100 c 2 This seems a little bit unnatural for me. may be i of the thrid row should be 101? -- Tatsuo Ishii t-ishii@sra.co.jp
В списке pgsql-hackers по дате отправления: