Re: [GENERAL] generating part of composite key

2007-07-28 Thread Jim Nasby
On Jul 26, 2007, at 5:57 PM, Stuart wrote: I have a table with a composite PK like CREATE TABLE t ( grp INT NOT NULL, itm SMALLINT NOT NULL, ..., PRIMARY KEY (grp,itm)); Normally the app takes care of providing the correct grp,itm values when inserting records. However (during

[GENERAL] generating part of composite key

2007-07-26 Thread Stuart
I have a table with a composite PK like CREATE TABLE t ( grp INT NOT NULL, itm SMALLINT NOT NULL, ..., PRIMARY KEY (grp,itm)); Normally the app takes care of providing the correct grp,itm values when inserting records. However (during a long period of development), I need to re