Received: from cncware.whidbey.com (IDENT:root@cncware.whidbey.com [208.25.171.37]) by hub.org (8.9.2/8.9.1) with ESMTP id WAA00811 for ; Sun, 7 Mar 1999 22:05:56 -0500 (EST) (envelope-from ken@ori-ind.com) Received: from ken (ken.cncware.com [192.168.61.201]) by cncware.whidbey.com (8.8.7/8.8.7) with SMTP id TAA08603 for ; Sun, 7 Mar 1999 19:04:46 -0800 Message-Id: <3.0.32.19990307190751.0088d650@ren.cncware.com> X-Sender: ken_ori@ren.cncware.com X-Mailer: Windows Eudora Pro Version 3.0 (32) Date: Sun, 07 Mar 1999 19:07:53 -0800 To: pgsql-interfaces@postgreSQL.org From: "Ken J. Wright" Subject: copy command & null datetime Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" The following example will cause COPY to fail on input: xxx|yyy|zzz||aaa|bbb| where the empty field in between zzz & aaa is of type datetime (don't know about other types). I know a \N will fix this, but interpreting an empty import field as NULL would certainly beef up COPY as other database systems don't output the \N which is unique to PostgreSQL. Wish list item? Ken