Re: Multiple insert

You are inserting ((),()). It should be (),(). Skip the outer set of parentheses.

On September 19, 2015 2:31:53 PM EDT, "FarjadFarid(ChkNet)" <farjad(dot)farid(at)checknetworks(dot)com> wrote:
>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
>
>
>
>

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.