> 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?
Aglio Database Solutions
In response to
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|