Hi, I am getting errors trying to insert multiple records in single statement in table like this CREATE TABLE "Lookup"."CNEnum1" ( "Id" integer NOT NULL, "Description" character varying(50), CONSTRAINT "PK_Lookup_CNEnum1 " PRIMARY KEY ("Id") ) WITH ( OIDS=FALSE ); INSERT INTO "Lookup"." CNEnum1"(" Id ","Description")VALUES((1::integer,'Desc1'::varchar) ,(2::ineger,''Desc2'::varchar)) I have tried various versions of sql statement. With field casting and without casting. Both work when a single record is inserted but with multiple records the same error is reported. ERROR: column "Id" is of type integer but _expression_ is of type record LINE 1: ... CNEnum1"("Id","Description")VALUES((1::int,'D... ^ HINT: You will need to rewrite or cast the _expression_. ********** Error ********** ERROR: column "Id" is of type integer but _expression_ is of type record SQL state: 42804 Hint: You will need to rewrite or cast the _expression_. Character: 73 Any suggestion would be greatly welcomed! And thank you in advance. Kind Regards Farjad |
