Hi, i m writing a C module (extension), the procedure has a parameter that is
of type numeric,
inside the function i can not read the parameter or so it seems, this what is
do:
float8 db_balance,in_chgval;
in_chgval = PG_GETARG_FLOAT8(2);
elog(INFO,"in_chgval = %0.2f",in_chgval);
The above
On 09/19/2015 11:31 AM, FarjadFarid(ChkNet) 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
On 09/19/2015 11:31 AM, FarjadFarid(ChkNet) 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
You are inserting ((),()). It should be (),(). Skip the outer set of
parentheses.
On September 19, 2015 2:31:53 PM EDT, "FarjadFarid(ChkNet)"
wrote:
>Hi,
>
>
>
>I am getting errors trying to insert multiple records in single
>statement in
>table like this
>
>
>
>CREATE TABLE "Lookup"."CNEnum
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
);
INSER
