Postgres Pro
Downloads
Home   >   mailing lists

Re: inserting a NULL timestamp - Mailing list pgsql-novice

From Robert Poor
Subject Re: inserting a NULL timestamp
Date
Msg-id AANLkTinpA_J0+ZuebqFmeiFR9HTXSunkCBrFCzNnKb-r@mail.gmail.com
Whole thread Raw
In response to Re: inserting a NULL timestamp  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-novice
Tree view 
@Steve:

On Tue, Mar 29, 2011 at 10:09, Steve Crawford
<scrawford@pinpointresearch.com> wrote:
> It's the select part that is causing your trouble. Try casting the null to a
> timestamp:
> ...as cost, null::timestamp as start_time...

Bingo.  Perfect - thanks.

pgsql-novice by date:

Previous
From: Steve Crawford
Date:
Subject: Re: inserting a NULL timestamp
Next
From: Robert Poor
Date:
Subject: updating records in table A from selected records in table B