I hope someone can gave me a hint / advice on this.
I wanted a auto-increasement function, similar to sequence, to increase a field. I cannot use CREATE SEQUENCE because it cd_line_no will start again with a new coursedetail.
TQ in advance.
TABLE ===== CREATE TABLE coursedetail ( cd_cf_id char(30), cd_line_no smallint default auto_increment by 1, cd_name char(40), cd_status char(2),
CONSTRAINT cd_pkey PRIMARY KEY (cd_cf_id, cd_line_no), FOREIGN KEY (cd_cf_id) REFERENCES course (cf_id) );
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
