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

In response to

• Cast NULL into Timestamp? at 2004-12-10 19:24:56 from Wei Weng

Responses

• Re: Cast NULL into Timestamp? at 2004-12-11 17:10:02 from Frank Bax

pgsql-sql by date

Next:	From: Joe Conway	Date: 2004-12-11 11:55:44
	Subject: Re: Create Calendar
Previous:	From: Kenneth Gonsalves	Date: 2004-12-11 05:00:55
	Subject: replacing mysql enum