X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C20CAD1B45E for ; Wed, 14 Jan 2004 08:01:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 43223-03 for ; Wed, 14 Jan 2004 04:01:02 -0400 (AST) Received: from domino.nc.com.my (domino.nc.com.my [202.185.214.131]) by svr1.postgresql.org (Postfix) with ESMTP id 7DAEFD1B44A for ; Wed, 14 Jan 2004 04:00:59 -0400 (AST) Subject: Re: Insert into:Bad date external representation To: pgsql-sql@postgresql.org X-Mailer: Lotus Notes Release 5.0 (Intl) 30 March 1999 Message-ID: From: azwa@nc.com.my Date: Wed, 14 Jan 2004 15:39:34 +0800 X-MIMETrack: Serialize by Router on domino/ANSI(Release 5.0.5 |September 22, 2000) at 01/14/2004 03:39:45 PM, Serialize complete at 01/14/2004 03:39:45 PM MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_alternative 002C361F48256E1B_=" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.8 tagged_above=0.0 required=5.0 tests=HTML_40_50, NO_REAL_NAME X-Spam-Level: * X-Archive-Number: 200401/121 X-Sequence-Number: 16514 This is a multipart message in MIME format. --=_alternative 002C361F48256E1B_= Content-Type: text/plain; charset="us-ascii" Hi, got an error as below : dwnc=> insert into biosadm.custdo_dim dwnc-> (do_key,do_no,do_date,attnto,custlo) dwnc-> select nextval('cdo_seq'),c.dono::varchar,c.dodate::date, dwnc-> c.attnto, c.custlo from custdo_temp c; ERROR: Bad date external representation '' Table structure (custdo_dim) : dwnc(> \d custdo_dim Table "biosadm.custdo_dim" Column | Type | Modifiers ---------+---------+------------------------------------------- do_key | integer | not null default nextval('cdo_seq'::text) do_no | text | do_date | date | custlo | text | attnto | text | Indexes: custdo_dim_pkey primary key btree (do_key) Table structure(custdo_temp): Table "biosadm.custdo_temp" Column | Type | Modifiers ----------+------+----------- dono | text | dodate | text | custname | text | custlo | text | attnto | text | pls help me thanks --=_alternative 002C361F48256E1B_= Content-Type: text/html; charset="us-ascii"
Hi,


 got an error as below :

   dwnc=> insert into biosadm.custdo_dim
dwnc->  (do_key,do_no,do_date,attnto,custlo)
dwnc->  select nextval('cdo_seq'),c.dono::varchar,c.dodate::date,
dwnc-> c.attnto, c.custlo  from custdo_temp c;
ERROR:  Bad date external representation ''


Table structure (custdo_dim) :  

dwnc(> \d custdo_dim
                  Table "biosadm.custdo_dim"
 Column  |  Type   |                 Modifiers
---------+---------+-------------------------------------------
 do_key  | integer | not null default nextval('cdo_seq'::text)
 do_no   | text    |
 do_date | date    |
 custlo  | text    |
 attnto  | text    |
Indexes: custdo_dim_pkey primary key btree (do_key)


Table structure(custdo_temp):

 Table "biosadm.custdo_temp"
  Column  | Type | Modifiers
----------+------+-----------
 dono     | text |
 dodate   | text |
 custname | text |
 custlo   | text |
 attnto   | text |

pls help me thanks --=_alternative 002C361F48256E1B_=--