Skip site navigation (1) Skip section navigation (2)

timestamp and null value

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 (view raw or flat)
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



Responses

pgsql-novice by date

Next:From: Bradley KieserDate: 2000-07-27 10:05:36
Subject: Re: 4 billion record limit?
Previous:From: Bradley KieserDate: 2000-07-27 10:02:04
Subject: Re: 4 billion record limit?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group