From: | "Nicolas Kizilian" <nicolas(dot)kizilian(at)kompass-france(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | timestamp and null value |
Date: | 2000-07-27 10:04:36 |
Message-ID: | 033b01bff7b2$1281d080$c9c809c0@kompassfrance.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I don't succeed in placing null values in a timestamp column.
This is an example :
create table entite (dt_creation timestamp null , dt_suppression timestamp);
insert into entite values ('', '1999-11-08');
ERROR: Bad timestamp external representation ''
Ok, that's my problem. Please note the fact that my "insert" command line
could not be modified, cause it's provided by a script, and I cannot modify
the script. I can't type for example :
insert into entite (dt_suppression) values ('1999-11-08');
wich would work.
I can't write it by hand, because I have more than 8,000,000 entries.
So if i can solve this problem just by modifying my "create table" line, it
would be great.
Thanks,
best regards,
Nicolas
From | Date | Subject | |
---|---|---|---|
Next Message | Bradley Kieser | 2000-07-27 10:05:36 | Re: 4 billion record limit? |
Previous Message | Bradley Kieser | 2000-07-27 10:02:04 | Re: 4 billion record limit? |