Message-ID: <2498.129.186.197.127.1074014921.squirrel@mail.eng.iastate.edu>
Date: Tue, 13 Jan 2004 11:28:41 -0600 (CST)
Subject: can insert 'null' into timestamp type field from command line but
	not from input file?
From: "Bing Du" <bdu@iastate.edu>
To: pgsql-sql@postgresql.org
User-Agent: SquirrelMail/1.4.2-1
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Importance: Normal

The table is like this:

========
maxware=# \d test;
               Table "public.test"
 Column |            Type             | Modifiers
--------+-----------------------------+-----------
 a      | timestamp without time zone |
 b      | integer                     |
=========

The following insert command works fine:

maxware=# insert into test (a,b) values (null,'1');

But importing from an input data file does not seem to work as shown below:

=========
maxware=# copy tbl_spcase from '/home/bdu/test/input.data' delimiter as '|';
ERROR:  invalid input syntax for integer: "null"
CONTEXT:  COPY tbl_spcase, line 1, column col_id_spcase: "null"
==========

The input.data file just has one line.  But no matter what I did, neither
of the following input format worked.

1. null|1
2. |1
3. ''|1

How should I represent blank value for the field that's of timestamp type?

Thanks in advance for any help,

Bing