Re: [SQL] Errors loading null dates in 7.0beta1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Colin Rothnie <colinr(at)tiwest(dot)com(dot)au>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Errors loading null dates in 7.0beta1
Date: 2000-03-08 08:36:31
Message-ID: 24547.952504591@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Colin Rothnie <colinr(at)tiwest(dot)com(dot)au> writes:
> I am unable to load data into version 7.0 beta1 when the date field is null.
> The same data loaded into the same table structure in 6.5.3 without errors.

FWIW, I don't see any obvious problem:

regression=# create table foo (f1 int, f2 date);
CREATE
regression=# insert into foo values (42, null);
INSERT 686666 1
regression=# select * from foo;
f1 | f2
----+----
42 |
(1 row)

Can you be more specific about your problem?

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Colin Rothnie 2000-03-08 09:12:43 FW: [SQL] Errors loading null dates in 7.0beta1
Previous Message Colin Rothnie 2000-03-08 06:36:21 Errors loading null dates in 7.0beta1