X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 7DBBC3A1D94
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 11 Dec 2004 05:11:56 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 20851-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 11 Dec 2004 05:11:52 +0000 (GMT)
Received: from davinci.ethosmedia.com (server226.ethosmedia.com
	[209.128.84.226])
	by svr1.postgresql.org (Postfix) with ESMTP id 441253A613D
	for <pgsql-sql@postgresql.org>; Sat, 11 Dec 2004 05:11:48 +0000 (GMT)
Received: from [63.195.55.98] (account josh@agliodbs.com HELO spooky)
	by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8)
	with ESMTP id 6772119; Fri, 10 Dec 2004 21:13:17 -0800
From: Josh Berkus <josh@agliodbs.com>
Organization: Aglio Database Solutions
To: pgsql-sql@postgresql.org
Subject: Re: Cast NULL into Timestamp?
Date: Fri, 10 Dec 2004 21:11:28 -0800
User-Agent: KMail/1.6.2
Cc: Wei Weng <wweng@kencast.com>
References: <41B9F808.2040909@kencast.com>
In-Reply-To: <41B9F808.2040909@kencast.com>
MIME-Version: 1.0
Content-Disposition: inline
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-Id: <200412102111.28104.josh@agliodbs.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=
X-Spam-Level: 
X-Archive-Number: 200412/52
X-Sequence-Number: 19672

Wei,

> insert into table temp (tempname, tempdate)
> select distinct 'tempname', null from some_other_relevant_table;

I don't think you're reporting the error exactly as it happened.  Try cutting 
and pasting your actual PSQL session into your e-mail.

Perhaps you are mixing up the column order?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco