hi
there is still error in "insert...select"
create 3 tables:
CREATE TABLE INT4_TBL(f1 int4);
CREATE TABLE FLOAT8_TBL(f1 float8);
CREATE TABLE TEMP_GROUP (f1 INT4, f2 INT4, f3 FLOAT8);
insert records
insert into INT4_TBL values(1);
insert into FLOAT8_TBL values(1.0);
INSERT INTO TEMP_GROUP
SELECT 1, (- i.f1), (- f.f1)
FROM INT4_TBL i, FLOAT8_TBL f;
now:
select * from TEMP_GROUP;
result is 0 row
|
