On Tue, Mar 29, 2011 at 10:09, Steve Crawford
> It's the select part that is causing your trouble. Try casting the null to a
> ...as cost, null::timestamp as start_time...
Bingo. Perfect - thanks.
In response to
pgsql-novice by date
|Next:||From: Robert Poor||Date: 2011-03-29 20:41:55|
|Subject: updating records in table A from selected records in table B|
|Previous:||From: Steve Crawford||Date: 2011-03-29 17:09:54|
|Subject: Re: inserting a NULL timestamp|