Bad timestamp external representation

Поиск
Список
Период
Сортировка
От Mark Tessier
Тема Bad timestamp external representation
Дата
Msg-id 20030428164554.6165d41b.m_tessier@sympatico.ca
обсуждение исходный текст
Ответы Re: Bad timestamp external representation
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Johnson, Shaunn"
Дата:
Сообщение: set passwd for users
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: set passwd for users