Hi,
When I try to insert with the "current" constant, as in:
herboris=> INSERT INTO cart (cartid, clientid, invdate, paydate) VALUES
herboris-> (4469858, 2, 'current_timestamp', 'now');
I get the following message:
ERROR: Bad date external representation 'current_timestamp'
This is how my table is set up:
/* --------------------------------------------------------
Table structure for table "cart"
-------------------------------------------------------- */
CREATE TABLE "cart" (
"cartid" int8 NOT NULL,
"clientid" varchar(8) NOT NULL,
"packnum" varchar(20),
"shipcost" numeric(5,2),
"prepinit" varchar(2),
"order_by" varchar(12),
"paytype" varchar(20),
"invdate" date NOT NULL,
"paydate" date,
CONSTRAINT "cart_pkey" PRIMARY KEY ("cartid")
);
GRANT ALL ON "cart" TO "apache";
GRANT ALL ON "cart" TO "mark";
ALTER TABLE "cart" ALTER COLUMN "invdate" SET DEFAULT 'now';
I changed "paytype" to type "timestamp" and that didn't work either. Could someone please tell me what "Bad external
representation"means, and hopefully what I'm doing wrong.
--
Thanks,
Mark