Re: Can it be done in SQL
Toby Denbow wrote:
>
> A serial is not ok for line_number because I do not want line_number to be
> unique across multiple records.
try this:
create temp table t ( col0 serial, col1 ..., col2 ...);
insert into t (col1,col2) select col1,col2 from table1;
insert into table2 (line_no, col1, col2) select * from t;
drop table t;hth
martin
-
Dr. Materna GmbH | EMail: Martin.Berns@Materna.De
Martin Berns | Tel.: +49 231/5599-231
Vosskuhle 37 | FAX: +49 231/5599-574
D-44141 Dortmund | X.400: S=BERNS;G=MARTIN;P=MATERNA;A=UMI-DE;C=DE